Using the Vlookup Function in VB Code

  • Thread starter Thread starter Juanfer
  • Start date Start date
J

Juanfer

Anyone has samples of VB code in which the Vlookup
function is used. I can´t get it to work.
 
Here's a sample:

mydata= Application.WorksheetFunction.VLookup _
(lookup_cell.Value, Worksheets("mysheet").Range("lookup_range"), 2)

hth,

Doug

Anyone has samples of VB code in which the Vlookup
function is used. I can´t get it to work.
 
Back
Top