Thread: True and True
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tim Childs Tim Childs is offline
external usenet poster
 
Posts: 128
Default 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