Howard,
VBA supports bitwise AND (and ORs). For example,
Dim X As Integer
Dim Y As Integer
Dim Z As Integer
X = 19 '10011
Y = 11 '01011
Z = X And Y ' Z = 3
Debug.Print Z
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Howard" wrote in message
...
I want to use boolean masking eg 10011 AND 01011 should return
00011 but I
just keep getting TRUE or FALSE from the AND operator. Is
there something
I'm missing or can EXCEL not do this?
Thanks for any help