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