ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Bitwise And (https://www.excelbanter.com/excel-programming/272289-bitwise.html)

Justin Starnes

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



Matthew Connor

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



All times are GMT +1. The time now is 02:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com