Hi all,
I am having issues with Codes.
Sometimes it work, sometimes it doesn't.
What I am trying to do is to save a copy of my existing worksheet to another file, I would also need to remove some sheets on that new copy.
Here is my code:
I am getting an error:![]()
Please Login or Register to view this content.
Run-time error '1004"
Application-defined or Object-defined error
On line:
ActiveWindow.SelectedSheets.Delete
Any ideas why?
Better yet, would you be able to recommend a better way of doing this?
Appreciate any help. Thank you.
Bookmarks