Last populated Row of a Table (VBA)

[Skybluekid]

Hi All,

I would like to get the last populated row of an excel table. In the table not all the rows will have text in, but I would the last row that is populated.

Thanks in Advance

 

[Akuini]

Try:

Sub test_2()
Dim rr As Long
rr = ActiveSheet.ListObjects("Table1").DataBodyRange.Find(What:="*", LookIn:=xlValues, lookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlPrevious, MatchCase:=False, SearchFormat:=False).Row
Debug.Print rr
End Sub

 

[Skybluekid]

Thank you @Akuini

 

[Akuini]

You're welcome, glad to help & thanks for the feedback.