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:

[cc lang=”vbscript” lines=”-1″ width=”100%”]myLastRow = ThisWorkbook.Sheets(“Sheet1”).Range(rows.count,1).End(xlup).Row[/cc]

Want more specifics? Watch the video below.

[frontpage_news widget=”14410″ name=”You Might Also Like”]

 

X

Forgot Password?

Join Us