Odd and even

[Francis Hookham]

I need to determine whether x is odd or even in a macro

= MOD(x, 2) works in a spreadsheet but

If MOD(x,2) = 1 then
etc

does not seem to work in a macro

Do you have any suggestions

Francis Hookham

 

[Ken Johnson]

Hi Francis,
In a macro x Mod 2 = 0 should be True when x is even.
Ken Johnson

 

[JE McGimpsey]

If MOD(x,2) = 1 then
etc

does not seem to work in a macro

Do you have any suggestions

There are a number of examples of VBA's Mod operator in VBA Help ("Mod
Operator")

 

[Francis Hookham]

Thanks ­ I should have checked out how MOD is used in Macro as opposed to
spreadsheet