Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange printing order
Hi,
I have one workbook and many sheets, sheet1, sheet2, ...,sheet10. In each of sheets I have some print areas. What I need is the order of the pages to be for example: page 1 and 2 form sheet2, then page 3 from sheet 10, then page 4 again from sheet1, page 5 and 6 from sheet6, page 7 from sheet1 etc. Also, I can not change sheets order in the workbook Hope you understand my problem. Is this possible at all, and if it is so does someone has a macro for this or any suggestion. Tx in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange printing order
Sub PrintSheets
sheet2.PrintOut From:=1, To:=2 sheet10.PrintOut From:=10, To:=10 [etc.] End Sub Jeff "emilija" wrote in message ... Hi, I have one workbook and many sheets, sheet1, sheet2, ...,sheet10. In each of sheets I have some print areas. What I need is the order of the pages to be for example: page 1 and 2 form sheet2, then page 3 from sheet 10, then page 4 again from sheet1, page 5 and 6 from sheet6, page 7 from sheet1 etc. Also, I can not change sheets order in the workbook Hope you understand my problem. Is this possible at all, and if it is so does someone has a macro for this or any suggestion. Tx in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
printing order of worksheets | Excel Discussion (Misc queries) | |||
A Strange Printing Problem | New Users to Excel | |||
Printing order | Excel Programming | |||
Printing in reverse order | Excel Discussion (Misc queries) | |||
strange printing/looping problem | Excel Programming |