Can i print non-contiguous areas on one page

[Guest]

Can i print non-contiguous areas on one page??

I don't wan't to do this with special paste or with image.

i wan't to do it automaticcaly for every sheet that i choose.

the range will be always the same (e.g A1:S2)

thank you in advantage

 

[broro183]

Hi Yiota,

Have a look at the section "Print selection or range with more areas on
one Page with a macro." & modify the code on Ron Debruin's page to set
the "smallrng" with your required range:
http://www.rondebruin.nl/print.htm

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...