I am using a code to delete a specific sheet. I get an error message that the sheet can't be found. The sheet does exist, is not the last sheet left, and only one Excel file is open. What am I doing wrong?
Please Login or Register to view this content.
Try and stay away from On error statements...rather test...
If this bypasses then the sheet does not exist...check leading or trailing spaces in sheet name...
Please Login or Register to view this content.Your code...As is should not show an error as you are bypassing this...Not sure if there is more to your code though...I get an error message
Last edited by Sintek; 10-11-2024 at 03:16 AM.
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks