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

How to get actual rows number in Excel using VBA?
 

..UsedRange means the cells have been used, but does not mean that they are
necessarily still in use.

..CurrentRegion is good for finding the current range, as long as it is a
continuous rectangular range. So Range("A1").CurrentRegion.Rows.Count tells
how many rows are included in the region starting at A1.
--
- K Dales


" wrote:

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

How to get actual rows number in Excel using VBA?
 

Got it!
Thank you very much, Dales!
It really helps!

michael

How to get actual rows number in Excel using VBA?
 

Got it!
Thank you very much, Dales!
It really helps!

michael

How to get actual rows number in Excel using VBA?
 

In a situation where that doesn't work, delete the extra rows (and/or
columns) using Edit/Delete, than Save. Sometimes I have to do a Save As.
You can use Ctrl+End to see what Excel sees as the end of the used range.

" wrote:

Got it!
Thank you very much, Dales!
It really helps!

michael