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