Application.WorksheetFunction problem
One option: In the vba editor, go to Tools | References...and add
"atpvbaen.xls"
Then...
Dim EvenQ As Boolean
EvenQ = IsEven(Range("A1"))
HTH :)
--
Dana DeLouis
Win XP & Office 2003
"Gary''s Student" wrote in message
...
I am trying to call ISEVEN() from VBA with:
Dim b as Boolean
b = Application.WorksheetFunction.ISEVEN(A1)
I am raising "Object doesn't support this Property or Method"
What is the correct syntax?
--
Gary''s Student
|