On submitting form, automatically go to next blank row.

[mynameismichael]

Hi guys,

I have searched and found quite a few threads on this but it doesnt seem to make sense to me, the answers being given.

I have an excel sheet with basic macros and about 6 headers, how can I get the form, once it has entered my data, to move to the next row available below my headers?

Hope this makes sense.

[alansidman]

You will have to use two lines of code.

1. Define the last row in a particular column

Please Login or Register  to view this content.

2. Set the value of the last row and add 1 so that it finds the next empty cell

Please Login or Register  to view this content.

Insert into your code where needed.