Sean,

Thank you for your time and the reply. Great start!

I have problems only when I have multiple print areas on a sinlgle
worksheet. The previous code selects all the print areas, i.e. all the
pages, to copy.

Is there a way to have it only select the first page/print area of the
wks(1) to copy and then move to page2/second print area of wks(1) and
copy?

Thanks again!

- Chris


--
Chris Shaw
------------------------------------------------------------------------
Chris Shaw's Profile: http://www.excelforum.com/member.php...o&userid=25041
View this thread: http://www.excelforum.com/showthread...hreadid=385660