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