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?

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?

This is perfect ... thanks, Mr. O!
"Tom Ogilvy" wrote in message
...
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?