worksheetfunction.vlookup returning run-time error (1004)

**Mervil** · 11-19-2010, 12:55 AM

In 10 minutes of searching the forums, I didn't find an answer to this question:

Please Login or Register  to view this content.

When I run this code, I get an error message, "Unable to get the VLookup property of the WorksheetFunction class". I know the individual arguments in that vlookup code are all correct; I can manipulate them each individually in the sub routine. Why can't excel find the Vlookup property (and why does it think its a property, not a method)?

thank you!

**Paul** · 11-19-2010, 12:59 AM

Hi Mervil,

Try just "Application.Vlookup" instead of "Application.WorksheetFunction.Vlookup"

**Mervil** · 11-19-2010, 01:23 AM

Ok. What the heck. That worked! But WHY did that work? I thought vlookup was a worksheetfunction.

**Paul** · 11-19-2010, 01:41 AM

I think it technically is part of WorksheetFunction, but doesn't work when that is added to the code. ::shrug::

Just something I've come across when trying myself.