Macro to save as PDF make pdf pages small and bigger as needed?

[tonywatsonhelp]

Hi Everyone,
I was wondering if there is a way to change the page size of the PDF according the how big the print area is?

For Example, I split my sheet and name 3 print areas
"B2:J15,B17:J45,B47:J87"
now this works fine but each PDF sheet is A4 size sheets,
I've seen a lot of PDFS where the PDF page Size depends on how much Data is on the sheet,
So for Example (And this may not be exact) but sheet one is 15cm long sheet 2 is 25cm Long and sheet 3 is 30cm long
can this be done in excel?

please help if you can as I've just finished a document and it looks an ugly mess all in A4 sizes.
thanks

Tony

 

[Logit]

http://blogs.adobe.com/acrolaw/2015/02/creating-a-pdf-at-the-right-output-size-and-dimensions/

https://docs.microsoft.com/en-us/office/vba/api/excel.pagesetup.fittopageswide

https://stackoverflow.com/questions/40219676/set-fit-to-visible-in-pdf-from-excel-vba