I have a sheet that takes a cell value and uses it as the name for a new sheet. Unfortunately some of the people using the sheet don't check to see if there is already a sheet with that name in the index and i have to trawl through trying to find incorrectly named sheets. Is there a way of generating an error message if there is already a sheet with the same name? Button code below. Thanks for taking the time to look
Please Login or Register to view this content.
Bookmarks