The IsOdd () function is in the Analysis Toolpack
- see
http://snipurl.com/kqja for a recent thread on
how to access these functions in VBA.
As others have said, though, it's very easy to do
it in plain VBA. My personal preference would be
to use the Mod operator:
Function myIsOdd (i as integer) as Boolean
myIsOdd = (i mod 2 = 1)
End function
Andrew Taylor
GoFigure wrote:
Excel version: 11 (2003 SP2)
OS: WXP SP2
What's the VBA code equivalent of the Excel IsOdd built-in formula?
It would great if one could use
Application.WorksheetFunction.IsOdd(range), but the IsOdd Excel
built-in is not available in VBA.
Many thanks,
- Al
--
GoFigure
------------------------------------------------------------------------
GoFigure's Profile: http://www.excelforum.com/member.php...fo&userid=4274
View this thread: http://www.excelforum.com/showthread...hreadid=492937