View Single Post
  #1   Report Post  
gana
 
Posts: n/a
Default Last non blank row in a worksheet

Hello,

Whenevr I try to get the number of rows in a worksheet, it returns 65526
which is actually the maximum number of possible in a sheet. If I have used
only 7 rows in a sheet, I want to get the answer as 7. How can I get?

Thank you