Thanks. I can handle doing it in VBA. My issue was that if I wanted to
retain column widths, row widths, ... With the gui PasteSpecial I can select
ColumnWidths, and it will copy the column widths but not the data. And I did
not see anything in the gui for copying row widts.

I guess I should really as -- how to copy an Excel Sheet to a new Excel
Sheet (or to another workbook) and keep everything intact. I know there is a
way to do this through the gui - I just can't remember how to do it.


"Jim Jackson" wrote:

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