Just to add to the other responses you have...

I bet that there are cells with values/constants that you want to keep--like
headers and descriptions.

So before you use the suggested techniques, select the range that you want to
clear first. It can include formulas (those will be eliminated with the special
cells stuff), but don't include any of the constants you want to keep.



denvancam wrote:

I am trying to save last years workbook, that accumulates data and totals
numbers. I need to erase last years inputed data, but want to keep the
formulaes intact. If I delete the data, it deletes the formulaes, if i clear
contents it does the same to the formulaes. I don't want to re-input the
same formulaes for every month in the year data base.

--

Dave Peterson