Anyone has samples of VB code in which the Vlookup function is used. I can´t get it to work.
J Juanfer Sep 4, 2003 #1 Anyone has samples of VB code in which the Vlookup function is used. I can´t get it to work.
D Doug Glancy Sep 4, 2003 #2 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.
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.
