VBA to clear cells don't have formulas needed !

[aysam]

Hi All
I have a large worksheet of about 1000 rows and 200 columns.
It had alot of formulas and a lot of cells to fill in using numbers.
I need a VBA code to clear only the numbers in the cells that don't have formulas.
Is it possible ??
Thanks in advance.

 

[jim may]

Highlight the entire range of both constants and formula cells; then press F5 to bring up the GoTo Dialog box; Click SPECIAL... Select CONSTANTS, then OK. Press Delete
All the Constants disappear.............

 

[aysam]

Thanks for the tip.It's Perfect
But
I need a VBA code because my Sheet is designed for Simple EXCEL users.

 

[Rick Rothstein]

Thanks for the tip.It's Perfect
But
I need a VBA code because my Sheet is designed for Simple EXCEL users.

Give this macro a try...

Sub ClearConstantsOnly()
  On Error Resume Next
  Cells.SpecialCells(xlCellTypeConstants).ClearContents
End Sub

 

[aysam]

Thanks very much. Works well
But
Is it possible to assign a range for the code to work on ?

 

[Rick Rothstein]

Thanks very much. Works well
But
Is it possible to assign a range for the code to work on ?

Sure... what range? If you mean you want to select the cells first, then change the word "Cells" in my code to "Selection". If, on the other hand, you want the same specific range everytime, then change the word "Cells" to this...

Range("A1:M123")

where you would use your actual range address for my A1:M123 example.

 

[aysam]

Thank you very much , Rick
It works very well
That's what I dtreamt