WorksheetFunction fails in 2003 !?

  • Thread starter Thread starter atakacs
  • Start date Start date
A

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
 
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)
 
Back
Top