Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a file with many sheets (say, 10) and on each sheet, I have
defined a range to print. I'd like to do the printing as one job, so I can highlight the sheets I want to print (say 1, 5, 7,10 by order of tabs from left to right) and run the print macro to print the active sheets. However, I want to print the ranges by another order (for example from sheets 10,1, 5, 7). I can do this by going to those sheets individually in that order, and printing individually, but then it's not one print job. Among other things, I lose the pagination sequence this way (yes, I can do a counter, etc) and also I can't print to a PDF printer as one combined job. Is there a way of printing ranges in the specific order (10,1,5,7) and still have the printing be one job? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What is the best way to organize a data in order to PRINT specific | Excel Discussion (Misc queries) | |||
Printing pages from different sheets in a set order | Excel Programming | |||
print specific worksheets in specific order. | Excel Programming | |||
Print Macro - Printing out of Order - 2nd Post | Excel Programming | |||
Print Macro - Printing out of order | Excel Programming |