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 vote269 views1 answer
How to check is the value enterd is a number or text in vba
VBA
0 vote274 views1 answer
Excel text to columns line break
VBA
0 vote323 views1 answer
How to call gcd in vba
VBA
0 vote278 views1 answer
Search combobox items vb.net
VBA
2 votes274 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
0 vote261 views1 answer
Excel vba disable mouse click
VBA
1 vote262 views1 answer
Excel vba first and last row and column in range
VBA
0 vote291 views1 answer
Excel vba named range exists
VBA
2 votes274 views1 answer
Vba split string
VBA
0 vote268 views1 answer
Sendkeys vba selenium
VBA