New sheet

  • Thread starter Thread starter Carl Johnson
  • Start date Start date
C

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.
 
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 **
 
Back
Top