| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting Rows in 2007
In many of my old macros I used the following code to get a row count in a
worksheet: CountRows = Range("A65536").End(xlUp).Row With the changes in 2007 I assume that I should use the following, more generic code now? CountRows = Cells(Rows.Count, "A").End(xlUp).Row -- Ken Hudson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help regarding CF - counting [Excel 2007] | Excel Worksheet Functions | |||
| Excel 2007 counting numbers | New Users to Excel | |||
| Counting characters in multiple rows when rows meet specific criteria | Excel Worksheet Functions | |||
| Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
| Counting Rows Then Counting Values in Columns | Excel Programming | |||
Threaded Mode
