Can i print non-contiguous areas on one page
 

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

Can i print non-contiguous areas on one page
 

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...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=526699