How do I make a cell truly empty using an "If" statement?
I think that if you are going to use formulas to test the cells, then the
best approach would be to test for null strings instead of ISEMPTY.
If ActiveCell < "" Then
Or
If ActiveCell = "" Then
Because if the cell is empty, then Excel will treat it like "". But that
would not solve the CountA dilemma.
"ALHR" wrote:
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
|