return an empty string in VBA
Dave
To "return an empty string" means that you want to see a blank cell.
Apparently that is not what you want to see. What do want to see? Otto
"Dave F" wrote in message
ps.com...
I'm trying to use the following code to return an empty string in a
range of cells if any value in the range is FALSE:
Application.EnableEvents = False
For Each R In Range("A1:A7")
If R.Value = False Then R.Value = ""
Next
Application.EnableEvents = True
The problem is this code returns the actual quote marks "" in the
cells, not an empty string. R is set as a variant.
What am I doing wrong?
Thanks.
Dave
|