VLookup in VBA

  • Thread starter Thread starter LarryP
  • Start date Start date
L

LarryP

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.
 
Hi Larry;

On thing to look at is that in the code below it has
Worksheets(2) which is referring to the sheet by index. I
would try switching it to the actual name such as
WorkSheets("MyWorkSheetName")

Thanks,

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

Using just application will often allow it to work.
 
If "LFLookup" is a range in the worksheet replace the quotes with square braces.
eg.... .Range([LFLookup]), etc
 
that would cause an error.

Either

..Range("LFLookup"),

or

[LFLookup]

would work, but not combined. Since there is nothing wrong with that part
of the code as written (as long as LFLookup is on worksheets(2)) then there
is no reason to change it.

--
Regards,
Tom Ogilvy



Twoo Doggs said:
If "LFLookup" is a range in the worksheet replace the quotes with square braces.
eg.... .Range([LFLookup]), etc
--
Paul M


LarryP said:
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.
Click to expand...
Click to expand...
 
Back
Top