Have Questions? 
Excel Ninja Pro
All Access

May 31, 2015

Getting the Last Row with Excel VBA

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.

Excel VBA Is Fun

We believe Excel is one of the most versatile programs out there - and learning to program and automate it makes you very valuable!

You can prevent wasted time and errors, speed up tasks and become indispensable to your organization. 

See how our trainees have gotten raises, promotions and bonuses using their Excel Automation skills while building real problem-solving programs in Excel!
Copyright © 2024 ExcelVbaIsFun

Forgot Password?

Join Us

    Your Cart
    Your cart is emptyReturn to Shop
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram