This is the way excel works with discontiguous print areas.

You do have a couple of options, though.

1. If you're lucky, you can hide the rows/columns you don't need to print so
that it looks like one contiguous range.

2. Copy the ranges to a new worksheet and print from there.

3. Copy the ranges, but paste as pictures on that new worksheet.
create a new worksheet
copy the first range (select, edit|Copy)
to the new sheet (select A1, shift-edit|Paste picture link)
do the same with the second range

What's nice about this is when you change the original ranges, the pictures
will update--so you don't have to worry about doing the work twice.

paul007 wrote:
>
> Ok we are getting there
>
> the set print area method is best for me as it prints only the info i
> require
>
> however i have another problem which is baffling me
>
> the selected print areas are on different parts of the page, but when i
> print the page each print area prints on a seperate sheet of paper
>
> when i setup the print areas from page break view i can see the
> highlighted print areas
> with page1,page2,page3 etc.. page1 being in print area1 and page2
> being in print area 2 etc...
>
> i want all the print areas to print on the same sheet of paper as its
> viewed on screen
> any ideas
>
> thanks in advance
>
> Paul007
>
> --
> paul007
> ------------------------------------------------------------------------
> paul007's Profile: http://www.excelforum.com/member.php...o&userid=28462
> View this thread: http://www.excelforum.com/showthread...hreadid=480793

--

Dave Peterson