Let's say you have a UserForm that saves entries to Sheet1. Each row of the sheet is utilized for a single "record".
Over a period of time you have managed to use all 1.4 million rows. Now there is a need to have the UserForm save
the entries to Sheet2 because it is the next empty sheet.
Without making a manual selection of Sheet2 or changing the macro code to save to Sheet2 ... how would you code
your macro the automatically identify the next empty sheet and proceed ? And ... after Sheet2 is full ... go on to Sheet3 ...
then to Sheet4 ?
Thanks.
Bookmarks