I suspect I'm looking for an impossible solution here, but I want a second and third opinion before I give up.

I have an excel document that creates a report with multiple sections. Manual page breaks are already in place to divide the sections onto different page breaks when they are printed.
However, sometimes one section is not applicable. When this is the case, the rows for that section are hidden. This results in blank pages being printed.
I am not printing the excel document to a printer, but instead printing them to a PDF document with VBA. As the report needs to be one document, I cannot use multiple print-jobs in order to exclude blank pages in the middle of the report.

Therefore, is there anyway that I can print multiple sections of the report as one print job, without changing the print area? I thought I might be selecting multiple page selections to print, but I haven't worked out a way to do that in one PrintOut statement.