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

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?
 
T

Tom Ogilvy

Activesheet.cells.SpecialCells(xlConstants,xlNumbers).Clearcontents

Regards,
Tom Ogilvy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to remove dashes in Social Security number 15
Macro Challenge – Create Table with Hours Worked and Copy Data 0
How can I remove the last 8 digits from every number 1
If specific cell is not empty, copy (or enter) formulas and format 2
Remove Duplicate Numbers in One Cell 5
number of months and days between two dates without approximation 3
Formula's won't read copy / pasted data ? 2
Chronological Numbering Spreadsheets 2

Top