Here's a sample:
mydata= Application.WorksheetFunction.VLookup _
(lookup_cell.Value, Worksheets("mysheet").Range("lookup_range"), 2)
hth,
Doug
"Juanfer" wrote in message
...
Anyone has samples of
VB code in which the Vlookup
function is used. I canīt get it to work.