Clearing or Deleting cells with formulas returning ""

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

scaryboy - 11 Mar 2006 09:55 GMT

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.

Reply to this Message

Dave Peterson - 11 Mar 2006 12:05 GMT

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.

> 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
[quoted text clipped - 3 lines]
> TIA
> Fred R.

Signature

Dave Peterson

Reply to this Message

scaryboy - 11 Mar 2006 17:00 GMT

Dave Peterson,

That worked perfectly. Thanks a ton

Fred R.

>Select your range to fix
>Edit|goto|special
[quoted text clipped - 14 lines]
>> TIA
>> Fred R.

Reply to this Message