It is sometimes useful to be able to check whether a number is odd or even.
Below is a very simple VBA function that does exactly that:
Function IsOdd(x As Integer) As Boolean
'------------------------------------------------------------------------
' Procedure : IsOdd
' Author : Zypher.co.uk
' Date : 09-Feb-2012
' Purpose : Check whether a value is odd or even
'------------------------------------------------------------------------
IsOdd = (x Mod 2) <> 0
End Function
'------------------------------------------------------------------------
' Procedure : IsOdd
' Author : Zypher.co.uk
' Date : 09-Feb-2012
' Purpose : Check whether a value is odd or even
'------------------------------------------------------------------------
IsOdd = (x Mod 2) <> 0
End Function
As always, I hope it proves useful.
