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 vote205 views1 answer
Do while not vb.net
VBA
0 vote215 views1 answer
Loop through all text boxes in a form vb
VBA
3 votes199 views1 answer
Vba folderexists
VBA
0 vote214 views1 answer
Create links in msgbox in vb
VBA
0 vote235 views1 answer
VBA
VBA
0 vote209 views1 answer
Vbscript abs
VBA
0 vote238 views1 answer
Amd64 vs arm64 linux
VBA
0 vote201 views1 answer
Vba border weight
VBA
0 vote204 views1 answer
Vba nested dictionary
VBA
0 vote221 views1 answer
Vba sort multiple columns
VBA