Next empty row - excluding formulas

Hello all,

I am making a userform for data entry and I am wanting my data to go in the next empty row, however there is one column that contains a formula all the way down the spreadsheet. Is there a way to have my code go to the next empty row ignoring the formulas?

Here is what I have

Please Login or Register  to view this content.

Use something like:

Please Login or Register  to view this content.

Choose a column that is fully populated but does not have a formula pre-populated.


Regards, TMS

Note: to comply with forum rules, please add code tags to your code excerpt.

Although not really necessary in this case, it is often helpful to upload a sample workbook. Then the response can be more specific and accurate.


Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Please post a sample workbook so we can see the structure and content of your workbook/worksheet(s)

Note: to comply with forum rules, please add code tags to your code excerpt. Having asked once already, I cannot provide a solution until you comply with the rules. However, if you do provide a sample workbook, I will investigate in the expectation that you edit your original post.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Thank you for adding the code tags and posting the picture. Unfortunately, as John has said, a picture helps a little but it does not allow us to understand the sheet content and formulae.

Please post a sample workbook

Regards, TMS

Please Login or Register  to view this content.

You probably need to check and remove blank rows. And you probably DON'T want to clear the row as you will lose the expiry date formula ... or you could just put it back in in the code.

Regards, TMS

Pretty sure your WHMIS CLASS is always going to be blank unless you pick the last option ... on the basis you check for a setting and, if it's not that, you blank it out. You just need to clear the cell once at the beginning and then test each of the Checkboxes for TRUE.

Regards, TMS