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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

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)

--
Regards,
Tom Ogilvy


atakacs wrote in message
...
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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/