HI,

I have been using Usedrange.Rows.Count function in most of my Macro Codes. It does very well. But in one sheet, it started counting as 1 row less than the total number of rows used.
That is, it shows 24 if 25 rows are used.
I copied the same data into another sheet. It showing properly. I am very curious to know what kind of error is this.

I understood that the formula uses only the number of rows used. It doesnt count empty rows if there are ny before the first used row.

Hi

You can try the following also to get the last row

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)