VBA Macro Code To Find Last Row In Excel

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