Start Entering Data on Row 30

[BigPaulMc]

I don't know anything about VBA...I don't know how I have gotten my form to work as much as it does, so please speak "English".

I want my userform to start writing data to the next empty row (as everyone wants) - but I want that first empty row to be C:30. I have a bunch of other things going on within rows 1-29. I have figured out how to start in column C, but I can't find a solution to start the data at row 30.

My code is below (sorry if I did not post it correctly) - if you are able to help, can you also explain where in my code I insert the lines?

Please Login or Register  to view this content.

And some other stuff here...

[Trebor76]

Hi BigPaulMc,

Welcome to the forum!!

I may have a solution but you'll need to wrap your code with the appropriate tags (simply highlight the code you've posted and click # from on the menu) as per Rule 3 here that you just agreed to when you registered before I can post it. Thanks.

Regards,

Robert

[BigPaulMc]

I did...just didn't highlight the text the first time around. Good to go now?

[Trebor76]

Great, thanks BigPaulMc

Try this for your emptyRow variable where if the next available row in column C is 29 or less it manually sets the variable to 30:

Please Login or Register  to view this content.

Regards,

Robert

[BigPaulMc]

Of course this works perfectly! Thank you!

[Trebor76]

You're welcome

If you could mark the thread as solved it would be appreciated.

Cheers,

Robert