Stop Excel from combining continuous PrintArea

[jpgactmod]

I have a worksheet with several continuous areas that I would like to print on separate pages. For example, two adjacent print areas are as follows:

CR6:CU77, CV26M77

When I use VBA to enter the above into Page Layout/PrintArea, Excel combines the PrintArea to CR6M77. Is there a way I can stop Excel from combining these adjacent print areas?

Thank you for any help.

Jim

 

[PHV]

Have a look at the VPageBreaks collection.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

hi

Try setting the print area for each in a loop
[tt]
'CR6:CU77, CV26M77
dim sRng(1) as string, i as integer
sRng(0) = "CR6:CU77"
sRng(0) = "CV26M77"

for i = 0 to ubound(sRng)
activesheet.PageSetup.printarea = sRng(i)
activesheet.print
next
[/tt]


Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

sorry Printout

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[jpgactmod]

I see. I assume that the second sRng(0) is meant to be sRng(1). Instead of setting the PrintArea, the VBA code prints each area one at a time. Correct? Yes, this works fine.

Thank you again.