Thanks for the info Ron, it's just what I have been looking for.
Now another week to figure out the best way of implementing it all and i'm
set.
Regards
Peter
"Ron de Bruin" wrote:
Maybe you like this
http://www.rondebruin.nl/print.htm#non-contiguous
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Peter" wrote in message ...
Hello,
I have a single excel worksheet, and due to area's of the sheet I do not
want to have printed, (the data is to be printed onto pre printed forms),
have used the set print area option to exclude those area's.
The problem is now I have multiple pages inside a single worksheet. Each
page prints seperatly, so I end up with 5 pages with only a small amount of
the full worksheet on each.
Thanks in advance
Peter