A quick update on the fix from here:

http://www.excelforum.com/excel-prog...ml#post2605180

Things are working great and the team here have been using the macro to print the pages with sequential numbers .

Only problem now is that when printing a large print run (say 200 sheets) the sequencing is getting mixed up (I guess this is happening in the print queue itself). With the relatively small numbers of sheets I was printing during the testing, this wasn't a big problem as the sheets typically were only transposed by 1 (IE sheet 8 coming out before sheet 7).

With the larger print runs, the errors are greater - up to 20 sheets out of sequence (IE sheet 162 comes out before sheet 144).

Is there any way of stacking up the print requests and sending them all as one batch (at present this is sending them to the printer one at a time), or possibly setting the priority of each sheet so that it necessarily comes out after the previous one?

Any help gratefully received as always,
Jus.