Thread: Bitwise And
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
Matthew Connor Matthew Connor is offline
external usenet poster
 
Posts: 17
Default Bitwise And

Justin Starnes wrote:

Can you do a bitwise and in VBA? If so, could someone post a small example?



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=e...icrosof t.com