Hi,
I'm using the following code to copy worksheets based on the contents of named ranges into a new workbook where the named range is entered into an InputBox.
The first part of the procedure works fine but when it gets to the SaveAs line it throws up run-time error 1004. I can get it to work by manually entering the file name but I would like the file to be saved as the name of the range ie. myRange.
Any help is appreciated.
Please Login or Register to view this content.
Bookmarks