Question : excel last used row
Answered by : vastemonde
Dim rLastCell As Range
Set rLastCell = ws.Cells.Find(What:="*", After:=ws.Cells(1, 1), _ LookIn:=xlFormulas, LookAt:= xlPart, SearchOrder:=xlByColumns, _ SearchDirection:=xlPrevious, MatchCase:=False)
MsgBox ("The last used column is: " & rLastCell.Column)
MsgBox ("The last used row is: " & rLastCell.Row)Source : https://stackoverflow.com/questions/11926972/how-do-i-find-the-last-column-with-data | Last Update : Sun, 07 Feb 21