-
Excel VBA Vlookup
Hi, question about using vlookups in vba. I know that accessing many Excel functions requires code such as
Code:
Application.WorksheetFunction.Count()
but when using vlookups it's
Code:
Application.VLookup()
as opposed to
Code:
Application.WorksheetFunction.VLookup()
When using the above code, with proper arguments within the lookup function, I get the following error:
Code:
Run-time error '1004':
Unable to get the VLookup property of the WorksheetFunction class
So VLookups aren't part of this class, whereas functions like Count, CountA, etc are? If they are, what mistake have I made? If not, how can I tell which functions aren't part of this class?
Thanks in advance