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

8 votes406 views1 answer
Run command pormpt in background windows
VBA
4 votes438 views1 answer
VBA Deep Clone Dictionary
VBA
0 vote351 views1 answer
Excel vba range contains
VBA
0 vote442 views1 answer
Winforms dark title bar
VBA
0 vote364 views1 answer
Replace spaces with underscores vbnet
VBA
0 vote364 views1 answer
String contins in vba
VBA
0 vote420 views1 answer
If statement vdhl
VBA
0 vote397 views1 answer
Vba count all row
VBA
0 vote359 views1 answer
Vb get ip address
VBA
0 vote375 views1 answer
How to mount floppy disks in vb.net
VBA