Visual Basic for Applications Reference
And Operator
Used to perform a logical conjunction on two expressions.
Syntax
result**=expression1And**expression2
The And operator syntax has these parts:
| Part | Description |
| result | Required; any numeric variable. |
| expression1 | Required; any expression. |
| expression2 | Required; any expression. |
Remarks
If both expressions evaluate to True, result is True. If either expression evaluates to False, result is False. The following table illustrates how result is determined:
| If expression1 is | And expression2 is | The result is |
| True | True | True |
| True | False | False |
| True | Null | Null |
| False | True | False |
| False | False | False |
| False | Null | False |
| Null | True | Null |
| Null | False | False |
| Null | Null | Null |
The And operator also performs a bitwise comparison of identically positioned bits in two numeric expressions and sets the corresponding bit in result according to the following table:
| If bit in expression1is | And bit in expression2 is | The result is |
| 0 | 0 | 0 |
| 0 | 1 | 0 |
| 1 | 0 | 0 |
| 1 | 1 | 1 |