View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dr.Schwartz Dr.Schwartz is offline
external usenet poster
 
Posts: 39
Default 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