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.