True and True
Frank
many thanks - it seems bizarre on the one hand but it certainly explains the
responses in the Immediate window
regards
Tim
"Frank Kabel" wrote in message
...
Hi Tim
in VBA TRUE evaluates to -1 (opposed to 1 in Excel formulas)
so in your case TRUE + TRUE = (-1) + (-1) = -2 and TRUE + FALSE = (-1)
+ 0 = -1
HTH
Frank
|