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!