| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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??? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
empty cell?
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. Lawson wrote: 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 Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
empty cell?
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 --- Regards, Norman "Lawson" wrote in message ... 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??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When is a cell empty and how do I empty it. | Excel Discussion (Misc queries) | |||
| Leaving an empty cell empty | Excel Discussion (Misc queries) | |||
| why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
| Empty cell and a the empty String | Excel Programming | |||
| VBA to copy to empty cell directly below a cell when analogous cells in different column have same value as each other? | Excel Programming | |||
Hybrid Mode
