Print selected page from diferent sheets

[popac]

In need to print page 2 to 5 from sheet2 and page 1,3and 9 from sheet3.I need to print 3 combinations of pages from different sheets. It is possible also to change the printing order of pages.
Thank You

 

[oliver_penney]

In need to print page 2 to 5 from sheet2 and page 1,3and 9 from sheet3.I need to print 3 combinations of pages from different sheets. It is possible also to change the printing order of pages.
Thank You

hi popac

have you thought about using named ranges and printing off using code?