Excel last used row

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: stackoverflow.com

Similar codes

0 vote150 views1 answer
Vba dictionary clear
VBA
0 vote169 views1 answer
Amd64 vs arm64 linux
VBA
0 vote128 views1 answer
Excel text to columns line break
VBA
0 vote141 views1 answer
Refer to resource using string variable vb.net
VBA
0 vote152 views1 answer
Vba registry settings
VBA
0 vote184 views1 answer
Excel vba delete columns in range
VBA
0 vote133 views2 answers
Excel vba close without saving
VBA
2 votes143 views1 answer
Vba round number
VBA
1 vote141 views1 answer
Excel vba get column number from column name
VBA
1 vote149 views1 answer
Export datagridview to excel vb.net
VBA