I am having a couple of problems with printing a sheets array:

(1) The pages don't print in the order given, such as:

Sheets(Array(SheetB.Name, SheetX.Name))

I would have expected SheetB before X. How does it process the array?

(2) If I pass in the names of 4 different sheets, sometimes (depending on
the sheets) it will combine all of this into one print job, containing 4
pages (when sent to the Image writer) and other times it will print 4 one
page jobs. How is this controlled?

Thanks for any help. Long day today!