Clearing or Deleting cells with formulas returning ""

  • Thread starter Thread starter scaryboy
  • Start date Start date
S

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.
 
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.
 
Back
Top