Problem with Range.Value

  • Thread starter Thread starter JLong
  • Start date Start date
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?
 
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.
 
Back
Top