Excel If statement with And operator

Question

I am migrating a complex excel macro to Java code. I have a code snippet as below in VBA. Could you please help in understanding the structure of this if block(expression). Thanks.

Here nLen is some positive integer.

If ((nLen - 1) And &H1) <> 0 Then
   //some code here
End If

Answer 1

And is the bitwise AND operator. &H is the prefix for a hexadecimal literal, so &H1 is 1. This is equivalent to (nLen - 1) Mod 2.

So, in a very roundabout way, what this code does is to check whether nLen is even.