Returning max number of rows

[Peter Bernadyne]

I'm trying to return the maximum number of rows used in a worksheet.
can run a loop each time to count however many cells I have populated
but this takes too long.

Isn't there a shortcut for this that I can use in my macro?

I thought I should be using Rows.Count but that gives me 65536 eac
time, not the actual number of rows I have populated on my worksheets.

Any help greatly appreciated!

-Pete

 

[Frank Kabel]

Hi
to get the last row of a column try

Dim lastrow as long
lastrow = activesheet.Cells(Rows.Count, "A").End(xlUp).Row

 

[Peter Bernadyne]

Thank you very much for your kind help.

I used this and it worked just fine. I can only hope I might be abl
to return the favor one day.

All the best,

-Pete