Thread: How to get actual rows number in Excel using VBA?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] michaellm@gmail.com is offline
external usenet poster
  
Posts: 11
Default How to get actual rows number in Excel using VBA?
Hi all,
Currently in my sheet1, the actual rows number is 20, that is,
only the first 20 rows have content in it.
But I use ActiveSheet.UsedRange.Rows.Count, and it gets 26, and
sometimes more.
Why?
How can I get the exactly 20?
Thanks.

michael

Reply With QuoteReply With Quote