ExcelBanter - Using the Vlookup Function in VB Code

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Using the Vlookup Function in VB Code (https://www.excelbanter.com/excel-programming/276120-using-vlookup-function-vbulletin-code.html)

Juanfer

Using the Vlookup Function in VB Code

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

Doug Glancy[_2_]

Using the Vlookup Function in VB Code

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.

All times are GMT +1. The time now is 04:53 AM.