New sheet

[Carl Johnson]

I want to edit/create a copy of a spreadsheet but when it opens I want it to
clear the contents but not the formatting of the page it was copied from.
Can I do this and how? Thanks in advance.

 

[Paul B]

Carl, try this, it will copy the active sheet and clear the contents, is
this what you need?

Sub test()
ActiveSheet.Copy Before:=Sheets(1)
Cells.ClearContents
End Sub


--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **