copying a style from one worksheet to another in the same workbook

[jbclem]

All the explanations I've found tell me how to copy a style from one
workbook to another, and it looks like they are referring to everything
within the originating workbook. What I want to do is, inside the same
workbook, open up a new worksheet and duplicate the formatting already in a
different worksheet in the same workbook.

Can someone tell me how to do this, I'm using Excel 2002.


John

 

[FSt1]

All the explanations I've found tell me how to copy a style from one
workbook to another, and it looks like they are referring to everything
within the originating workbook.  What I want to do is, inside the same
workbook, open up a new worksheet and duplicate the formatting already ina
different worksheet in the same workbook.

Can someone tell me how to do this,  I'm using Excel 2002.

John

hi
see this site. i think it does what you want.
http://office.microsoft.com/en-us/excel-help/using-styles-in-excel-HA001110199.aspx

regards
FSt1