Hi Excel Gurus,

I've got a VBA questions I was hoping you guys could help me with.
There is a workbook I currently need to print on a monthly basis, however the pages in the workbook are not in the right order (for printing).

Imagine there are 5 sheets (Sheet1 trough Sheet5) with each having 3 pages.
All of the pages need to be printed, but not in the order of page 1 trough 15.

Is there a code that allows the user to print page 10,5,7-9,13,etc in a specific predefined order?
Since the total length and order are fixed, these can be hardcoded in the VBA code.

If possible, if final file could be one PDF file that would be amazing.

I'm just starting out with learning VBA and any advice would be really appreciated!