Is there a way to remove numbers w/o remove formulas

  • Thread starter Thread starter Annette
  • Start date Start date
A

Annette

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,xlNumbers).Clearcontents

Regards,
Tom Ogilvy
 
Back
Top