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 vote200 views1 answer
Columns dont autoresize on program start vb.net
VBA
13 votes339 views2 answers
Vba write text file
VBA
0 vote171 views3 answers
Write to text file vb.net
VBA
0 vote168 views1 answer
Add items to combobox vb.net
VBA
0 vote219 views1 answer
Visual basic run command
VBA
3 votes167 views1 answer
Vba folderexists
VBA
1 vote172 views1 answer
Excel vba make cell visible
VBA
0 vote179 views1 answer
Windows Forms dark title bar
VBA
0 vote173 views1 answer
Vbscript abs
VBA
4 votes177 views2 answers
Vba create folder if not exist
VBA