why does VBA this statement ignore 0 values - it shouldnt

[mahmed1]

Hi All

Hoping you can help me understand why this is ignoring 0 values when it shouldnt - it is a number and ive tested it

If c.Value <> "" And c.Value <> Empty And c.Value <> "Ok" And c.Value <> "Not Ok" Then
'do something

Thank You

 

[Scott T]

If you remove c.Value <> Empty then the if statement is true. Looks like the 0 is being seen as empty.

 

[Norie]

What do you mean by 'ignoring'?

 

[mahmed1]

Hi Norie - it was not including 0s a number and treating it as empty

 

[shg]

If c.Value <> "" And Not IsEmpty(c.Value) And c.Value <> "Ok" And c.Value <> "Not Ok" Then

 

[mahmed1]

Hi SHG - thank you

ill give that a go - whats the difference between

Not IsEmpty(c.Value)

and

C.value <> empty

 

[shg]

VBA coerces 0 to Empty for comparison purposes. IsEmpty tests the Variant Type in the cell, which is always String, Boolean, Double, Error, or Empty.

 

[mahmed1]

Thank YOU SHG