Quote Originally Posted by xld
No, although I didn't word it especially well, I don't think that was the point I was making. You can exploit a numerical value for True in both Excel and in VBA, in Excel the numerical equivalent of True is 1, but in VBA the numerical equivalent of True is -1. To demonstrate,

In Excel, in a cell type =N(TRUE), you get 1

In VBA, in the immediate window, type ?CLng(TRUE), you get -1,

whereas the numerical equivalent of FALSE is 0 in both.
Right, but the question here is why?!?! Can you find this in the Help files? No. I haven't seen any Microsoft documentation on this behavior. It has been exploited tremendously in the Newsgroups and had much conversation by many experts and MVP's (which include the likes of Aladin Akyurek, Harlan Grove, Tushar Mehta, the list goes on), to which you have various findings.

I think I'll leave the rest up to those experts and MVP's.

Quote Originally Posted by xld
I didn't express a preference for any of the forms, although I do have one!
I think we all do!