6/18/2023 0 Comments Excel how many rows in the sheet![]() Unlike databases tables (such as Access), Excel tables are not always continuous. (See line 3 of macro “countDataRows2” below) You’ll only have to select any cell within the list before running the macro. We can enhance the macro to have it automatically find the “CurrentRegion” of the table range. However, you may find it inconvenient to have to manually select the entire list before running the macro. MsgBox tmp & amp " rows of data in the selection" ![]() The macro also returns the answer in a message box. To use the macro, we first select the list of data, and run the macro. ![]() The macro “countDataRows1” below uses to find the number of rows of data in the current selection. It is easy to find the number of rows in a list like this. The list in continuous with no “broken rows” in between (i.e. In this example, we have a list of monthly expense data as shown in the picture below.
0 Comments
Leave a Reply. |