The code below works perfectly to save two ranges as .pdf. I cannot work out how to get the zise of the .pdf to 1 sheet wide and 1 deep to enable easy printing later of the .pdf.
Thanks for any helpPlease Login or Register to view this content.
The code below works perfectly to save two ranges as .pdf. I cannot work out how to get the zise of the .pdf to 1 sheet wide and 1 deep to enable easy printing later of the .pdf.
Thanks for any helpPlease Login or Register to view this content.
Last edited by BRISBANEBOB; 05-06-2014 at 10:23 PM. Reason: Solved
Perhaps:
Please Login or Register to view this content.
Last edited by JBeaucaire; 05-06-2014 at 10:55 AM. Reason: added suggestion
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hi
Tried that but it is still saving the .pdfs as two pages wide.
Any suggestions?
Thanks
I added a tweak above that might help.
Hi
I added the tweak and when the code hits it I get the error message 'Object doesn't support this property or method'. I am running 2007 if that makes a difference.
Oops:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks