Thread: VLookup in VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
tod tod is offline
external usenet poster
 
Posts: 114
Default VLookup in VBA

If LFLookup is a variable, then you should not put quotes
around it.

-----Original Message-----
Am trying to use the VLookup function in VBA code, and

the
following line won't run:

intPointValue = Application.WorksheetFunction.VLookup
(varRawData, Worksheets(2).Range("LFLookup"), 9, True)

I get runtime error 1004, "Unable to get the VLookup
property of the WorksheetFunction class."

What am I missing? I tried several variations but can't
seem to make VLookup work, even though the Help says it
will. Any hints most appreciated.
.