Hi all,
I have a UserForm which submits data to another worksheet; it also specifies an autonumber for each new record, however I have some code which finds the fist empty cell and the two don’t work together well.
The code makes a number appear in cell A1 but places the UserForm data underneath it in A2
Is it possible to amend the code allow the auto number to appear in A1 and UserForm data to appear in B1
Here is the code:
Many thanks,Please Login or Register to view this content.
Adele
Bookmarks