ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Sheet Array Printing (https://www.excelbanter.com/excel-programming/385832-sheet-array-printing.html)

Troubled User

Sheet Array Printing
 
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!


All times are GMT +1. The time now is 05:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com