Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Even and Odd
IS there a keyword in Visual Basic that recognizes whether a number is odd or
even. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Even and Odd
If you have Analysis Toolpak loaded and set a reference to it in VBA, then
ISODD() and ISEVEN() are available -- Kind regards, Niek Otten "aftamath" wrote in message ... IS there a keyword in Visual Basic that recognizes whether a number is odd or even. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Even and Odd
You could 'roll your own'
Function test(num) As Boolean test = (num Mod 2 = 0) End Function -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "aftamath" wrote in message ... IS there a keyword in Visual Basic that recognizes whether a number is odd or even. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Even and Odd
Could you explain a little more on how to call these functions and an exampl
of code for them. How t oset a reference? Thanks in advance. "Niek Otten" wrote: If you have Analysis Toolpak loaded and set a reference to it in VBA, then ISODD() and ISEVEN() are available -- Kind regards, Niek Otten "aftamath" wrote in message ... IS there a keyword in Visual Basic that recognizes whether a number is odd or even. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|