Find the Last Row in an Excel Worksheet Using VBA
By Hemanta Sundaray on 2021-09-04
The following line of code finds the last row in a sheet in which column A has a value and assigns it a label named LastRow.
LastRow = Cells(Rows.Count, 1).End(xlUp).Row