| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine the size of a range
Say I have values in cell A5, A6 and A7, what is the easiest way to determine:
1. The number of rows in the range (answer = 3) 2. The last row number in the range (answer =7) The first row number is known (5) as variable: fstRow I can do it by counting every cell until I get to the first empty cell with a Do until...loop routine, but it seems like a lot of code to determine a simple thing. Agree? Thank you The Doctor |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to determine what is causing large size | Excel Discussion (Misc queries) | |||
| Determine size of listbox | Excel Discussion (Misc queries) | |||
| determine range size after auto filter? | Excel Programming | |||
| How to determine a range size | Excel Programming | |||
| How to determine JPG size in pixels? | Excel Programming | |||
Threaded Mode
