There is probably a simple solution for my problem, however I am just learning VBA.
I am using the attached code to name a worksheet. It works fine until I use a name that is already used on a worksheet in the workbook.
I want to have the option to enter another name that is not a duplicate.
Any suggestions would be accepted with gratitude.
ThanksName.txt
Name2.txt
Bookmarks