J Justin Starnes Jul 22, 2003 #1 Can you do a bitwise and in VBA? If so, could someone post a small example?
M Matthew Connor Jul 22, 2003 #2 Justin said: Can you do a bitwise and in VBA? If so, could someone post a small example? Click to expand... Apparently all of the VBA logic operations are already bitwise. The following is stolen from an old post by Myrna Larson: Function BitWiseAND(Number1 As Long, Number2 As Long) As Long BitWiseAND = Number1 And Number2 End Function from http://groups.google.com/groups?hl=...ff&[email protected]
Justin said: Can you do a bitwise and in VBA? If so, could someone post a small example? Click to expand... Apparently all of the VBA logic operations are already bitwise. The following is stolen from an old post by Myrna Larson: Function BitWiseAND(Number1 As Long, Number2 As Long) As Long BitWiseAND = Number1 And Number2 End Function from http://groups.google.com/groups?hl=...ff&[email protected]
