empty cell?

[Lawson]

how come blank cells have a value of greater than 0???

i have a simple formula:

If Range("b10") > 0 Then Range("h31") = 1

b10 is blank, yet is still sets h31 = 1

how do i get around this???

 

[Debra Dalgleish]

B10 may contain a space character, so it looks empty, but isn't.
Select cell B10, and press the Delete key, and that may fix the problem.

 

[Norman Jones]

Hi Lawson,

Your observed result is consistent with B10 containing a formula which
returns "". It is not consistent with B10 being empty.

To deal with the first scenario, try:

If IsNumeric(Range("B10").Value) And Range("B10") > 0 _
Then Range("H31") = 1