Fast and easy. Just two lines of vba code to get/find the last row of a set of data (aka count the number of rows) in an Excel spreadsheet.
Dim LastRow As Long LastRow = Cells.Find("*",SearchOrder:=xlByRows,SearchDirection:=xlPrevious).Row
Advertisements
Leave a Reply