How To Find The Last Row In an Excel VBA Range

You are adding data on a consistent basis to your spreadsheet, and you need to have a macro that references the last row that was just added to your Excel spreadsheet data range or table. This article and associated video will show you how to do just that. So similar to “Fig 1” above you would like to reference row 14 of the table and possibly iterate over each of the cells. The YouTube video below will take you through the details of how to reference the last row with a vba range object, I will summarise how to do this here, and you can download the Excel vba macro spreadsheet that goes with the tutorial below. The basics of the solutions are coded below Line 5 gets a reference to all the data in Fig 1 above. Line 8 creates a new variable that references the header in spreadsheet row 3 Line 11 then creates a new variable that references the last row of the range by offsetting the rngHeader variable by the number of rows in the data range (rngData). The loop that begins on line 10 of the code below creates an iterator (rngCell) that will loop over each cell in the last row, you can use rngCell to do whatever you want to do to each cell in the last row. In reality, I never use select, unless I’m debugging code and want to verify my range references. If you have any questions about this tutorial, feel free to enter them in the comments section below. That’s all for now, thanks for reading.