Print range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have 2 - 8 1/2 x 11 sheets that we put on one worksheet as one page, but print as 2 pages. Is there a way to designate 2 print ranges at one time and print the entire worksheet at one time, as two pages? It is a wide financial document, with multiple columns that extends over more than one page in width. Currently, I set two different print ranges and print the sheet twice. Anything easier? Thanks.
 
You could do your normal print setup one more time and this time Record a
Macro while doing it.......then in the future just run the macro and it will
do all the stuff for you automatically........Tools > Macro > Record new
macro..........

Vaya con Dios,
Chuck, CABGx3


BEV said:
We have 2 - 8 1/2 x 11 sheets that we put on one worksheet as one page,
Click to expand...
but print as 2 pages. Is there a way to designate 2 print ranges at one
time and print the entire worksheet at one time, as two pages? It is a wide
financial document, with multiple columns that extends over more than one
page in width. Currently, I set two different print ranges and print the
sheet twice. Anything easier? Thanks.
 
Back
Top