Macro to save to PDF and retain 11x17 landscape

[Dougl]

Hello all,

I need to save an Excel worksheet to PDF and retain it's paper size of 11 x 17 landscape. Below is the macro I currently have and it runs but saves the pdf in 11 x 8.5. Any help is greatly appreciated.

Please Login or Register  to view this content.

[arcticsponge]

Hi Dougl,

Just set the page orientation before you print using the sheet.pagesetup method/member

Please Login or Register  to view this content.

[Cutter]

@ Dougl

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.