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 vote255 views1 answer
Excel vba combine ranges
VBA
0 vote252 views1 answer
Convert number to minutes in vba
VBA
3 votes266 views2 answers
Vba active workbook path
VBA
0 vote225 views1 answer
Vba find last column in a row with data
VBA
8 votes381 views1 answer
Excel vba determine number of elements in a 1D array
VBA
0 vote225 views1 answer
Vba add month to date
VBA
0 vote269 views1 answer
Vba timestamp -- milliseconds
VBA
1 vote235 views1 answer
Add control vb
VBA
8 votes257 views1 answer
Run command pormpt in background windows
VBA
0 vote248 views1 answer
Weekday vba
VBA