Printing printranges from different sheets in a specific order and as one print job
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?
|