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 vote133 views1 answer
Reset border color textbox vba
VBA
1 vote141 views1 answer
Vb.net get name by Selection Changed
VBA
0 vote122 views1 answer
VB Error Code BC30201
VBA
0 vote80 views1 answer
Vba set vs dim
VBA
8 votes172 views1 answer
Excel vba make word
VBA
1 vote135 views1 answer
Excel vba first row in range
VBA
0 vote121 views1 answer
Excel vba range contains
VBA
0 vote115 views2 answers
Excel vba prevent save
VBA
0 vote125 views1 answer
Vb test if reference is null
VBA
0 vote139 views1 answer
If statement vdhl
VBA