Find Next Blank Row for Data Entry Using VBA

A useful macro to find the next empty or blank row in an Excel worksheet
Let’s say you wish to calculate and then transfer data from a userform via a macro to an Excel worksheet. The first step involves finding out where the next empty or blank row lies. In our example we have a database already in place with the titles ‘Item’ and ‘Unit’. We have described how you find out the next empty row for data entry using a macro. The macro gives a message with the empty row number. Based on this information you can build a more detailed userform as shown in the next training videos.In an earlier example we had described how to achieve the same thing using the offset property.

View the training video:

7 thoughts on “Find Next Blank Row for Data Entry Using VBA

  1. Terry from Australia

    I am fairly competent in Excel, but I find your tutorials very enlightening and full of new little tricks.

    But, how can I copy the VBA code that you demonstrate in your videos.

    As I like to build up a library of interesting little excel procedures.

    Thanks for all your great tutorials.

    Regards Terry from Australia.

  2. Pingback: Transfer Data to Specific Excel Worksheet Using VBA | Excel VBA Training Videos

  3. Pingback: Copy non blank data from sheet1 to sheet2 with VBA | Excel VBA Training Videos

  4. Sulley

    I followed your lecture with keen interest. I seem to understand every bit of it, but when i tried it the cursor could not locate the last empty row. rather i get only the count number. Also i noticed you did not define the erow but it worked for you, Is there a secrete? When i tried without defining the erow it dose not work for me.

  5. Pingback: Copy paste data repeatedly from sheet1 to sheet2 | Excel VBA Training Videos

Leave a Reply

Your email address will not be published. Required fields are marked *