And this returns bEven as true for 1.9, but False for 2.9, and vice versa
for bOdd!

Bob

"JE McGimpsey" wrote in message
...
One way:

Dim bEven As Boolean
bEven = variable Mod 2 = 0


Dim bOdd As Boolean
bOdd = variable Mod 2 = 1


In article ,
"PraxisPete" wrote:

Hi Everybody
I think this should be straight forward but brain is just not working
today
How can I use VBA code to determine if the contents of a varible is odd
or
even?

Many thanks