#Excel VBA to Select the Next Empty Cell or Row - Macros

200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content

How to find the next or last empty row in Excel using VBA Macros - this includes selecting the last cell or row and inputting data into it.

I'll show you different methods for selecting the next empty cell, within the data set or at the bottom of it, and this includes a full break-down of every part of the code that is required to do this.

You are able to simply download the workbook and copy/paste the code to use in your workbook, or watch the tutorial to get a thorough understanding of each part of the code.

As well, at the end of the tutorial, I will show you the proper way to use this method within a larger macro so that you can have better, more robust, code in Excel - this does require more code initially, but will help you a lot when making larger macros.

I hope you find this tutorial useful!

#excel #vba #howto

[roderickmuro]

This is perfect, exactly what I was searching for and well explained. Appreciate the awesome tip!

[enzobormann]

You really save my life trying during hours to try something to find the next empty row.
Thanks !

[darrylmorgan]

Excellent Tutorial, Easy to Follow!Thank You Sir :):):)

[wayneedmondson]

Hi.. great.. always good to practice manipulations in VBA. Thanks and Thumbs up!

[Jake]

Thank you so much!!! I was looking for this exact thing and I will try it tomorrow.

[ramzein]

thanks sir I just learned something new once again Thank you very much

[Phenom]

That's EXACTLY what I needed, thanks !

[zubairkahn]

Hi, thanks for the video. How to select all cell from A1 (Red) to A6 (Black) including the empty cell using VBA code?

[tziki]

Hi. I want that when I look for the next empty raw and type hi it will type the next number . Like 1, 2, 3, 4, 5, 6, can u make it thanks

[sherryizzie]

Great explanation! Is there a way to select all the empty cells in the worksheet and input a single value?

[carlo]

I just tried to copy data (databodyrange) from a "formatted Table" in sheet 1 and paste it into the next empty row of another "formatted Table" in sheet 2 using Range("A1").End(xlDown).Select,
It worked fine(It went right below the header), but when I try a second time with the same data set from sheet 1 using the same code I lost the last row of the 1st attempt(overwriting the last row).

Any suggestions?

[alejandroesquivelcordero]

What if I need o do this on a filtered list? I need to move to the cel on the first row of a filtered list anc copy it. I tried doing it as explained in this video but I don't go to the first cell on the filtered list but to the first cell on the sheet (just below the filter row).

[eyaldavid]

An amazing detailed tutorial. Thank you very much!
I have a question, please:
I have a table of groceries and i have a button that opens a form to add a new one with several columns (name, price, weight, place of purchase etc).
==> My question is regarding a new function (form) i want to add a "Delete Row" -
By clicking a button that approves the action I want to delete Only specific collumns on the exact Row that is currently selected (skipping formulas in my sheet).
On my vba code i can go to ActiveCell - but I don't know how to extract just the line number out of it.
From there I will try to use select range for each column with that line number and mybe add a For loop to raise lower filled rows 1 row up to minimized the gap. :)
Thanks

[michaelabrams]

Very Newbie here...How would you change this to find the next empty column? Thank you

[theunknownmarket]

On a basic workbook, I tried to execute this macro: "Range (“S9”).End(xlDown).Offset(1).Select", but it came back with this error: "APPLICATION ERROR '1004' Application - defined or Object-defined error". Am lost as to how to fix this. Help please if possible. THANK YOU!

[tj]

I have a named range of seven rows and three columns that I enter data into from a userform starting in the 1st row and 1st col and filling from left to right. So let’s say I’ve filled the first 5 cells. Is there a way of finding the next empty cell in the range for the next entry using a similar method to the one you use here ? Thanks.

[WhosShamouz]

Awesome video! I can’t get it to work with columns though :/ any idea?

[joeyorpilla]

it help a lot but what if i want to add border line in the selected rows

[robinluvsrap]

Can this help to select the first empty cell in filter?

[ajaykatiyar]

Please any explain for Column, How to do same things in column....???