I have a macro to create new sheets with various names in the workbook. How can I check whether a worksheet name already exists? A simple function like Function DoesSheetExist(worksheetName) as boolean would be useful to me. Any & all help is appreciated.
This one line If-Evaluate method is one I use.
If you want a function, try something like this...
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by AlphaFrog; 10-15-2014 at 11:42 AM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Many Thanks. Just what I was hoping for.
-Stu
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks