Unable to get the VLookup property of the WorksheetFunction class
the best advice is, don't use worksheet functions in VBA.
I see you are using Offset, but why use vlookup at all then?
Use ONLY offset. It's actually more useful and easier to use than
vlookup anyway.
|