Loading...
Uploaded by nagileon on Jun 18, 2008
Find the last row in excel using VBAVisual Basic. Peter Kirklewski, Senior VBA programmer. tel: 0048787950948 in EU or 0013157794406 in NY.
Education
Standard YouTube License
lastro = Sheets(1).Range("a" & Rows.Count).End(xlUp).Row
MsKemas 1 year ago
want something easier?
lastrow=activeworkbook.sheets("sheet1").cells(65536, 1).end(xlup).row
gusamarante 3 years ago
I am a naughty? ho! Y
andrew567567 3 years ago
Load more suggestions
lastro = Sheets(1).Range("a" & Rows.Count).End(xlUp).Row
MsKemas 1 year ago
want something easier?
lastrow=activeworkbook.sheets("sheet1").cells(65536, 1).end(xlup).row
gusamarante 3 years ago
I am a naughty? ho! Y
andrew567567 3 years ago