Saving a sheet as a landscape fit-to-width PDF

I have a sheet with data that is generated with some other VBA code. It uses columns A-J, and number of rows is varying. I need to save the sheet as a PDF, landscape and fit to width. Any ideas how to do that?

Before saving as a PDF file, go to Page Setup and set the orientation to landscape.

Artik

Originally Posted by Artik

Before saving as a PDF file, go to Page Setup and set the orientation to landscape.

Artik

Thanks for the reply!
I was thinking about the code to this automatically. Not sure what the next step would be.

Please Login or Register  to view this content.

I forgot about your "fit to width" request. Change references as required.

Please Login or Register  to view this content.

I use the following code:

Please Login or Register  to view this content.

Thanks for the replies!

If that is what you need and it works for you, good to know and thanks for letting us know.
You should get used to setting a PrintRange though.
Good luck.