Hey all!
I've written a code to save a couple of selected pages as PDFs. My code works, saving it in the correct file path with the correct names and all. The problem is, the saved PDF has a third, blank page, when there should only be two. The selected ranges on both sheets go up to 46, and both are on one page, so I know it's not that.
Thank you for any help!
Please Login or Register to view this content.
Last edited by hindotmo12; 08-26-2019 at 11:56 AM.
Hi,
In this case, nobody can know where the mistake is if you don't attach the real workbook.
Hi,
Sorry about that, I guess I just assumed it would be a coding issue. I've just updated the OP with the attachment.
Your workbook has a strange error. Hide all unused rows and columns may be helpful.
What/where is the error? I don't think I can hide unused rows, as the sheets are formatted to be used as forms. It's such a basic sheet right now, maybe I ought to just start from scratch?
Thank you
I ran into errors when I would run the code twice, telling me to debug. I think it didn't want to save the same file name over an existing file. It caused Excel to freeze, and even froze my library folder. Maybe that did it?
Hi Hindotmo,
I have encountered this error. The error is if you fit the contents into 1 page, when printing the contents will be zoom out. I don't know why.
After sheets are group selected, use ActiveSheet. The other Activate and Select are not needed.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks