Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup with tableLookup is external workbook
Hello, i try use in VBA the Worksheetfuncion Vlookup with table lookup
another workbook. Sub test() Dim Look As Range Dim tLook As Range Set Look = Cells(2, 2) ---------------Error in next line ("P" is a name range)----------------- Set tLook = Workbooks("c:\temp\test.xls").Sheets("test").Range ("P") ActiveCell = Application.WorksheetFunction.VLookup(Look, tLook, 10, 0) End Sub Any help is appreciate Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup to an external file | Excel Discussion (Misc queries) | |||
vlookup not updating from external workbook | Excel Worksheet Functions | |||
Vlookup in external file | Excel Worksheet Functions | |||
Vlookup referring to External Workbook or Spreadsheet | Excel Worksheet Functions | |||
VLookup to an external Workbook | New Users to Excel |