I have a userform that creates a new worksheet, enters data from the form,
and performs calculations based on that data. One of the entries on the form
is an ID which becomes the name of the new worksheet. How can I check the
names of all the worksheets (indefinite number of sheets) to verify the new
ID isn't a duplicate and stop the program from running? The desired result
is to prompt the user for a new name and then run the procedure. I tried an
If...Then...Else statement, but it's renaming and overwriting the original
and still creating a new blank sheet. I hope I haven't confused you! Thanks!