Function FindLastRow()
Dim LastRow As Long
If WorksheetFunction.CountA(Cells) > 0 Then
'Search for any entry, by searching backwards by Rows.
LastRow = Worksheets("data").Cells.Find(What:="*", After:=[A1], SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
FindLastRow = LastRow
End If
End Function
Find Last used row in a Worksheet
Article by Mukesh Dak
Mukesh has written 253 awesome articles for us.
If you liked this post, you will definitely enjoy our others. Subscribe to the feed via RSS or EMAIL to get instantly updated for those awesome posts soon to come.
Previous post: Find Last Column used in a Worksheet
Next post: Excel – Create New Worksheet
