Thanks for your response. To be a little more clear, what I am trying to do
is assign a group of cells a value if a certain condition is true, and leave
them empty if false. What I have done in the past is used "" in my "if"
statement for the false condition. The problem is that while the cell
appears to be empty, Excel treats it as though it contains text.


"Norman Jones" wrote:

Hi ALHR,

With VBA, try,

Range("A1").ClearContents

If, however, your intention is to work
from Excel , it is not possible for a
formula to '"empty" a cell; at most,
a formula can make the cell seem empty.


---
Regards.
Norman
"ALHR" wrote in message
...
If the condition is false, I want the cell to be empty. When I use ""
counta() and other functions treat the cell as text.

Thank you