VBA sets print margins for 9 pages, but they don't print in the right order

[UncleBajubjubs]

Hello, I have code to set the print margins on an excel sheet with 9 sheets printed. The code is the following:


<code>
ActiveSheet.PageSetup.PrintArea = "$A$14:$P$87,$A$88:$P$155,$A$162:$P$221,$Q$14:$AE$87,$Q$88:$AE$155,$Q$162:$AE$221,$AG$14:$AV$87,$AG$88:$AV$155,$AG$162:$AV$221"
</code>

Which I would think would make it print like
1 4 7
2 5 8
3 6 9

But it instead prints
1 3 7
2 4 8
5 6 9


Any suggestions?

 

[shg]

The order in which you specify the address string of the print range has no affect on the order in which it prints. Excel will print down then across, or across then down; that's it.

If you need something different, set the first page print area, print, second page, print, ...

 

[UncleBajubjubs]

I tried switching it to 'across, then down' as it was already on 'down, then across', and now they order is


1 2 7
3 4 8
5 6 9

Neither option is doing what it should be doing.

 

[shg]

So ...

If you need something different, set the first page print area, print, second page, print, ...

 

[shg]

Or hide col AF and set the print area to $A$14:$AV$155, $A$162:$AV$221