How to force Set the number of printed pages (2 in this case) of a range
===

How do I force a range in Excel VBA say ("a1:z60") to print ONLY two pages page(1) from ("a1:z40") and page(2) from ("a41:z60"). 

Also separately, how can I force the same range say ("a1:z60") to print ONLY two pages page(1) from ("a1:p60") and page(2) from ("q1:z60"). 

In addition I want the zoom to be maximum possible (under the given conditions) for each of my two pages.

Many Thanks