Problem with Range.Value

[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?

 

[JE McGimpsey]

One way:

=ISBLANK(A1)

 

[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.