msgbox "the column is " & _
Left(ActiveCell.Address(0,0), 2 + (ActiveCell.column < 27))

would be an example of exploiting True is equivalent to -1

--
Regards,
Tom Ogilvy

"davidm" wrote in
message ...

I want to exploit the fact TRUE equtes to -1 but cannot get my head
around the conditions surrounding this. I have experimented in code
with MsgBox (5=(50/10)) , or some such direct equality , but each time
simply get the result TRUE.

How can I wrest *minus 1* from a TRUE boolean relationship?


--
davidm
------------------------------------------------------------------------
davidm's Profile:
http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=390606