Printing Multiple Sheets to One PDF file

[johnnywinter]

I have code to print out selected sheets from one workbook. Have it and it works great thanks to leahProton.

I now need to save those selected mulitple sheets as a single PDF file, so I found code to do that. (opver all problem is to spool all printing s a single job)

I can get each code to work separately, but not together.

I need some help, please!

Thanks, J



Here is my code to printout the selected sheets"

Please Login or Register  to view this content.

AND HERE IS THE CODE TO SAVE MULTIPLE SHEETS AS A SINGLE PDF FILE

Please Login or Register  to view this content.

[FrankBoston]

I have made changes without testing to show an approach. Changed lines are marked with Change9

Please Login or Register  to view this content.