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

Discover the Secrets of Excel Your Coworkers Don't Want You To Know and Your Boss Will Love You For...

Thanks... Video will load in just a sec...

Discover the Secrets of Excel Your Coworkers Don't Want You To Know and Your Boss Will Love You For...

Thanks... Video will load in just a sec...

0
    0
    Your Cart
    Your cart is emptyReturn to Shop