Clearing or Deleting cells with formulas returning ""

[scaryboy]

I need a macro line that will delete the contents of cells in a range
that have formulas that return a blank cell. the if formulas in the
cells return "" or some number. i need to empty the cells that do not
return a number.

TIA
Fred R.

 

[Dave Peterson]

Select your range to fix
Edit|goto|special
Select Formulas
But uncheck Numbers
Leave Text, Logical, Errors checked
Click Ok

Now hit the delete key.

If you record a macro when you do it, you'll have your code.

 

[scaryboy]

Dave Peterson,

That worked perfectly. Thanks a ton

Fred R.