I am looking for a solution similar to the one in this thread.
http://www.excelforum.com/excel-prog...orksheets.html
Only difference is I need to export to PDF. I have attempted to modify the code provided with no luck.
Thanks,
I am looking for a solution similar to the one in this thread.
http://www.excelforum.com/excel-prog...orksheets.html
Only difference is I need to export to PDF. I have attempted to modify the code provided with no luck.
Thanks,
Hi, dmarzean,
maybe have a look at this code (based on the thread you linked):
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Getting same error as when I tried to modify.
Method 'Copy' of '_Worksheet' failed
This line highlighted wsCurrent.copy
How would I modify to use a cell value and nothing to do with the sheet name?
When I run the code from the other post I get same error on this line Sheets(strSheetname).Copy
My Modifications in rep
Please Login or Register to view this content.
Hi, dmarzean,
a guess: is the sheet visible if you want to copy it?
Ciao,
Holger
Well, I feel like an idiot. Didn't even look at my hidden sheets to exclude.
Your code works perfect!
Thank you Sir.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks