How to export range to a single PDF file?

[GIS2013]

Hi,
I'm trying to export a specific range in a specific sheet into PDF file.
The code below creates, for some reason, a multiple-pages PDF file, but I need the entire visible range from A5:I65 to be exported to a single pdf page.
I'd be glad to hear any directions.
Thanks

Please Login or Register  to view this content.

[lecxe]

Hi

... but I need the entire visible range from A5:I65 to be exported to a single pdf page.

Try using the PageSetup of the worksheet to fit that area to 1 page.

[GIS2013]

Hi, sorry for the late reply.
@lecxe - you provided a good lead, and here is what helped me:

Please Login or Register  to view this content.

[lecxe]

I'm glad it helped. Thanks for the feedback.