Thread: USEDRANGE
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AK AK is offline
external usenet poster
 
Posts: 56
Default USEDRANGE

I use this in VB to check the no. of row used in the activesheet:-

ActiveSheet.UsedRange.Rows.count

BUT if the first row is blank then the total no. of row will be minus by one.
How can the total no. of rows(including the first blank row) be counted?