return an empty string in VBA
Do you mean you actually see the two quote marks in the cell after the code
is run? That is not what happens on my system... the cell is totally empty.
Rick
"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
|