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. Could you explain a little more on how to call these functions and an example of code for them. How to set a reference to the Analysis toolpak for iseven(), isodd()? Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Even and Odd
It's generally more efficient just to use the Mod function:
Const nTest As Long = 42 Dim bIsOdd As Boolean Dim bIsEven As Boolean bIsOdd = nTest Mod 2 = 1 bIsEven = nTest Mod 2 = 0 MsgBox "bIsOdd: " & bIsOdd & vbNewLine & "bIsEven: " & bIsEven In article , "aftamath" wrote: IS there a keyword in Visual Basic that recognizes whether a number is odd or even. Could you explain a little more on how to call these functions and an example of code for them. How to set a reference to the Analysis toolpak for iseven(), isodd()? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|