Good afternoon,
I am trying to automate part of a work process where the spreadsheet in use will print a PDF document to the users default printer. I have been researching how to do this and I am of the understanding that it is either very difficult or not possible to select two sheets and print them back to back within excel, so I have gone down the route of creating the two sheets as one PDF document. I am trying to understand how to print off the PDF within the same code, as this is planned to work via a Macro Button.
I've included my current code below, I would appreciate any advise or insight that can be offered.
Bookmarks