Array of Print Range to Output to PDF

[mikeymay]

I have a number of worksheets in a file that have their print ranges set and I would like to display them as a PDF file where the user can select whether to print or not.

There are sheets in the file which do not need to be printed so I can't reference the workbook.

Thanks

 

[Aaron Blood]

I answered a very similar question a week or so ago...

Save as PDF

...the code in my second post is what you need to emulate.

 

[mikeymay]

Thats exactly what I need!

Thanks Aaron