In VBA

Range("A1:Z600").Copy
Workbooks(wbk2).Activate
Sheets("Sheet1").Range("A1").PasteSpecial xlPasteFormats
Sheets("Sheet1").Range("A1").PasteSpecial xlPasteFormulas (or xlPasteValues)
--
Best wishes,

Jim


"Rich" wrote:

How do you copy an Excel sheet to another sheet - or create a new worksheet
and use the same formatting as another sheet? Like sheet 1 columns A-M are
.5 width. How can I copy the contents of sheet1 to Sheet2 and preserve the
formatting in sheet1?

Thanks,
Rich