Thread: empty cell?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lawson Lawson is offline
external usenet poster
 
Posts: 15
Default empty cell?

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