how 2 GET last non-empty row number

[abyss]

i need a number, NOT a region.
a simple integer.
how can i get it? (VBA)

 

[erik.van.geit]

oh, no, PCC
I'm glad to learn !
only you could have said method doesn't ALWAYS work
your code wasn't new for me since it's applyed in deleting unused rows and columns to pull down filesize, but I simply elaborated the code of Willr and didn't think of the anytime-anywhere-solution you had
everybody should use yours
it's great to work and learn together

regards,
Erik

 

[Mr Walker]

I always use what PCC uses, with one slight alteration, and it's always worked great for me.

LastRow = Sheet1.Range("A:C").Find(What:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row

 

[Legacy 21301]

ActiveSheet.UsedRange.Rows.Count

If you want the last used row, that won't always do it.

You need :-

Range([A1], ActiveSheet.UsedRange).Rows.Count

 

[erik.van.geit]

Ponsy,
could you explain what's the difference ?
what is Range([A1], ActiveSheet.UsedRange).Rows.Count doing that ActiveSheet.UsedRange.Rows.Count doesn't ?

regards,
Erik

 

[Legacy 21301]

In a blank worksheet enter something in A2 and run :-

Sub x()
MsgBox ActiveSheet.UsedRange.Rows.Count
End Sub

Then run :-

Sub x()
MsgBox Range([A1], ActiveSheet.UsedRange).Rows.Count
End Sub

 

[erik.van.geit]

thanks,
good example
tryed also MsgBox Range([A65], ActiveSheet.UsedRange).Rows.Count
to understand what's hapening

kind regards,
Erik