Print Multiple Sheets & a dynamic number of pages

[dabrows]

I can really use a hand on this one.

Basically I have three separate sheets that I want to save to PDF. The first two sheets ("Cover" and "Inputs") are one page each the last sheet is called "Report" - I want to be able to select a specific number of pages from "Report" to add to the PDF and not just all of the pages on the "Report" sheet. The determining factor is a boolean value that I have stored. I have been able to save one PDF file by grouping the relevant worksheets but I am stumped on this one. Below is the code:

Can this be done with a Dynamic Print area?

Any and all help is much appreciated!! I hope everyone is staying safe!

Please Login or Register  to view this content.