Carrying formatting automatically to new W/S

[Jonah]

When I copy a workbook I want to be able to maintain the formatting and layout.

Whenever I have done this, the new worksheet always loses the formatting from the original.  For example the original has some emboldened text, but on the copied sheet the emboldening has been lost.

Jonah

 

[Ragdyer]

Right click on the sheet tab(s),
Select "Move or Copy",
Click on "Create a Copy",
Expand the "To Book" box and click on "New Book",
Then <OK>.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

When I copy a workbook I want to be able to maintain the formatting and layout.
Whenever I have done this, the new worksheet always loses the formatting

from the original. For example the original has some emboldened text, but
on the copied sheet the emboldening has been lost.

 

[Jonah]

Sorry about this, but it is not a new W/B but a new worksheet I needed. I also
tried what you said and I still get no formatting carried over.

J

 

[Ragdyer]

Might there be some underlying code in the sheet?

This procedure copies a sheet *exactly*, whether the original is protected
or not, whether it's saved or not ... it just works!

Describe exactly what you did, and where you did it.

 

[Jonah]

Underlying code? Where do I look?

Jonah
-------------