dim c1 as currency = 0
dim c2 as currency = 10
dim v1 as variant = c1
dim v2 as variant = c2
if v1 < v2 then
// This works
end if
c2 = 214749
v2 = c2
if v1 < v2 then
// FAILS!!
end if
If the spread between the currency values is > 214,768, the Variant comparison will not work property.
Wait, there’s more. It seems to be a multiple thing. I tested from 0 to 10 million, and found that these ranges work. Everything outside these ranges do not work.