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 vote196 views1 answer
Vbs write file
VBA
0 vote192 views1 answer
Vbscript Trim
VBA
0 vote208 views1 answer
Vba first cell in range
VBA
0 vote207 views1 answer
Vb run command
VBA
0 vote201 views1 answer
For each item in folder outlook vba
VBA
0 vote191 views1 answer
Putting marquee in vb.net
VBA
22 votes327 views1 answer
Xl vba check for folder
VBA
0 vote207 views1 answer
Do while not vb.net
VBA
0 vote209 views1 answer
Vba remove numbers from string
VBA
1 vote196 views1 answer
Excel vba get ordinal number from cardinal number
VBA