Problem with Range.Value

J

JLong

I am having problems determining if a single cell range
value is zero or empty. How could I now if the cell is
empty of its value is Zero?
 
J

Jack Schitt

In VBA, try
IF ISEMPTY(Range("cellref"))

I tried this and it evaluated to false when there was zero entered in
cellref, and true when I deleted the zero.

=ISBLANK() has a similar effect when called as a worksheet function.
 
Top