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

1 vote177 views1 answer
Add rows to datagridview vb.net
VBA
0 vote180 views1 answer
Vbs run with cscript
VBA
0 vote169 views1 answer
Vba parameter adodb null value
VBA
0 vote162 views1 answer
Vb check if row has column
VBA
0 vote185 views1 answer
Excel filter by date not working vba
VBA
0 vote154 views1 answer
Le contrôle SpinButton (Toupie)
VBA
0 vote187 views1 answer
Excel web scraping
VBA
0 vote163 views1 answer
Vba leading zeros in string
VBA
-1 vote175 views1 answer
How to correct a number to 2 decimal places in vba
VBA
1 vote174 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA