Thanks for feeding back.

Pete

On Mar 25, 9:39*pm, AFD at FONO
wrote:
Many thanks. *This came close to solving my problem and worked perfectly with
my test workbook. *However, when I tried it on a production workbook I got a
message that said only copy the first 255 characters in a cell would be
copied. *Inserting page breaks manually and resetting the print area manually
for each worksheet is much easier than finding all the cells whose contents
has been truncated.



"Pete_UK" wrote:
Why don't you just copy the sheet ? (CTRL-drag the sheet tab) Then you
will have an identical sheet, and you can easily remove data (leaving
formulae intact) by Edit | GoTo | Special | Constants and pressing the
<delete key.

Hope this helps.

Pete

On Mar 25, 5:45 pm, AFD at FONO
wrote:
I want to copy ALL the formatting and page setup information from one
worksheet to several others. *I've found a way to copy some of the page setup
information but the print area definition isn't copied. The other problem is
that page breaks are not copied. *I'm using Excel 2003.- Hide quoted text -

- Show quoted text -