Re: VLookup in VBA

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 06/18/04 

Date: Fri, 18 Jun 2004 09:45:28 -0400

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

Using just application will often allow it to work. 

-- 
Regards,
Tom Ogilvy
"LarryP" <anonymous@discussions.microsoft.com> wrote in message
news:1e47401c45536$d886bbc0$a501280a@phx.gbl...
> 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.
Quantcast