First Empty Cell In A Column (Excel VBA)

Locating first empty cell in a column is a common issue for alot of macros that are designed selecting cells or pasting values to orher cells. Here is a quick and very easy approach for this issue.

Lets break first empty cell in a column phrase to get a better understanding. What we are looking for is;

  • A cell
  • With a value = “” (empty)
  • Inside a known range

So here is how you seach for an empty cell in a column A:

Sub Find_First_Empty_Row()

Dim x As Range                                           ‘   Declare a variable as a range object

For Each x In Range(“A:A”)                      ‘  Search for our range object inside column A

If x.Value = “” Then                                    ‘   Check whether cell value is blank

x.Select                                                          ‘   Select the cell

Exit For                                                         ‘   Stop searching

End If                                                            ‘  End condition

Next x                                                            ‘   End loop

End Sub

For more tutorials, visit our Excel VBA Category.

You may also like...

3 Responses

  1. Tina says:

    Filylna! This is just what I was looking for.

  2. http://www./ says:

    Now I know who the brainy one is, I’ll keep looking for your posts.

  3. What’s up,I check your blog named “First Empty Cell In A Column (Excel VBA) – Beat Excel!” like every week.Your story-telling style is awesome, keep it up! And you can look our website about fast proxy list.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.