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.

There are some print setups that cannot be done on grouped sheets.

Print Range, rows to repeat at top are included in these "some"

Page Breaks would be a function of your print range being replicated..

You must use VBA code to do that.

For anyone interested in the code see this google search result with Dave
Peterson and myself posting. The print area code is from Bob Flanagan.

http://snipurl.com/106kz


Gord Dibben MS Excel MVP

On Tue, 25 Mar 2008 10:45:00 -0700, 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.

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.

I appreciate your response but it doesn't solve my problem. The next
response does solve the problem.

"Gord Dibben" wrote:

There are some print setups that cannot be done on grouped sheets.

Print Range, rows to repeat at top are included in these "some"

Page Breaks would be a function of your print range being replicated..

You must use VBA code to do that.

For anyone interested in the code see this google search result with Dave
Peterson and myself posting. The print area code is from Bob Flanagan.

http://snipurl.com/106kz


Gord Dibben MS Excel MVP

On Tue, 25 Mar 2008 10:45:00 -0700, 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.

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.

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 -