One of the most important things you’ll learn in Excel VBA is grabbing the last row in your code. Here’s how to do it.

Let’s say we need the bottom used cell in column A (column 1), we can copy/paste this code for the row number:

myLastRow = ThisWorkbook.Sheets(“Sheet1”).Range(rows.count,1).End(xlup).Row

Want more specifics? Watch the video below.

Get the FREE eBook. . .
Signup today and receive free updates straight in your inbox plus we'll send you the "Essential Excel VBA Snippets" eBook. We will never share or sell your email address.