Macro to Print Multiple (Selective) Excel sheets to One PDF

Hi all,

I am new to code and trying to figure out how to print multiple pages to PDF. I have sifted through other posts and found how to make it work when you have specific set pages to print. My problem is that I am trying to only print certain pages according to the iinformation in a particular cell on each sheet. I have the code to actually print out the worksheets tied to a button on my cover page and everything works great. When i tried to convert the code over to print to PDF I have had nothing but problems. I have included what I have for printing below. Can anyone help me convert this to print to pdf?

Please Login or Register  to view this content.

My best recommendation is to:

1) Create a temporary wb
2) Check each of these pages in you current wb and if that sheet/range needs to be printed, copy that sheet/range to a new sheet in the new wb
3) Repeat for all sheets in main workbook, thus creating a new wb with all the sheets/ranges wanted only
4) Print the temp workbook as a whole to a PDF
5) Close the temp wb without saving it