Hello,
I have been looking through the forum for a while and I have not seen a clear response to this here or anywhere.
By way of background; I have a workbook that copies a template worksheet (using a macro button) and the user inputs their first and last name. It then formats the name using a first initial underscore last name scheme (i.e. J_Doe), It is this abbreviation that is then used to name the tab. The issue I run into, is there may be a John and Jane Doe, so I would like for the macro to identify when this error is going to occur and append a number to the back end of the users abbreviated name (i.e. J_Doe1). My current script achieves this, BUT it only allows for one duplication before an error occurs. I am looking for the macro to identify when the error is going to occur again and assign the next entry to J_Doe3 when naming the book. How can this be achieved, please see my script below.
Thank you!Please Login or Register to view this content.
Bookmarks