Save Current Worksheet as PDF

Hey all,

[view sample spreadsheet]

I have a spreadsheet that is quite wide. I am trying to print a report [pdf] of the data. The report would have multiple pages rather than shrinking to one page.

I currently have a code but this works only on sheets with one page. Is there anyway to edit this code I have so it detects all the data to the right and adds it on subsequent pages to my PDF report? I am open to doing this anyway that works.

I have a preference to keep each table on it's own page, rather than breaking it up cause it doesn't fit in the margins.


Would appreciate any help i can get, even if it is just advice

All the best guys!

Gotcha appreciate your comment. I am a little too new to be able to dynamically create the print area through code. A little over my head not coming forma coding background. Do you have any ideas or help for me?

You guys are so helpful. I appreciate your time you took to help me. AlphaFrog and YasserKhalil you're awesome seriously

Originally Posted by YasserKhalil

You're welcome ..
And thanks a lot for Mr AlphaFrog for his great efforts in the forum
Best Regards for all of you

Hey Yasser, how do I change the file path ont his code. I can't seem to figure out where you guys embedded it