last row, final row [excel/vba]
finalrow = Cells(Rows.Count, 1).End(xlUp).Row
finalrow = Cells(Rows.Count, "C").End(xlUp).Row
finalrowORcolumn = Cells.Find(What:="*", SearchOrder:=xlRows, SearchDirection:=xlPrevious, LookIn:=xlValues).Row ' or LookIn:=xlFormulas