Print selected page from diferent sheets

popac

New Member
Joined
Dec 5, 2005
Messages
2
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
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

oliver_penney

Board Regular
Joined
Dec 18, 2002
Messages
182
popac said:
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,016
Messages
5,569,628
Members
412,284
Latest member
Daibear
Top