WorksheetFunction fails in 2003 !?

[atakacs]

Folks,

for some reason the following code fails in Excel 2003

Application.WorksheetFunction.VLookup(x, y, z,
false)

with error

"Unable to get the Vlookup property of the WorksheetFunction class"

What gives ?

And yes, I have checked the various security options in the Macro
Security Tab.

Any pointer appreciated

--alexT

 

[Tom Ogilvy]

Does vlookup find a match. If not, it will return an error. If you test it
in the worksheet and it works with the equivalent arguments, then
Try using

Application.VLookup(x, y, z,false)