Hi John,

Try:

ActiveSheet.Cells.SpecialCells(xlCellTypeConstants , _
xlNumbers).ClearContents

---
Regards,
Norman



"John" wrote in message
...
Clearing worksheets also clears the formulas. So does delete. How can I
clear a worksheets without destroying the formulas in the worksheet.

I run macro, edit it then want to run again but with the worksheets
cleared. When I clear them, I have to reenter all the formulas.

JOhn