Activesheet.cells.SpecialCells(xlConstants,xlNumbe rs).Clearcontents

Regards,
Tom Ogilvy

"Annette" wrote in message
...
I have a ss that has formulas sporatically throughout and in certain areas
each month, numbers are entered. Each year, we take the same spreadsheet
and clear out those data entered numbers, leave behind the formulas and
start over.

Is there a way to clear the spreadsheet inputted numbers without clearing
the forumlas?