Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
LOOKUP function in VB Macro.
Remove NOGI and NOGO for e-mail address
(NO Garbage In - NO Garbage Out) Esteemed Group Participants and Lurkers: I can't seem to get the lookup function to execute in a complex macro I am writing. Here is what I am trying to do: Workbook with active sheet with macro: H:\Test\MyTestBook.xls Sheet1 Workbook with lookup source: D:\Work\My WorkBook.xls SheetX Lookup Table is named "myTable" The lookup table works fine, but I can't get it to work inside the macro. I have tried cut and paste and other things, but haven't gotten anything to work. Here is the closest I can come: Dim i As Long i = 7 Cells(1, i) = Application.WorksheetFunction.Lookup_ (Cells(2,i), 'D:\Work\My WorkBook.xls'!myTable) Any suggestions as to how to get this to work? Thank you for any comments, suggestions, or assistance. Blessings in abundance, all the best, and ENJOY! Art Du Rea Carlisle, PA USA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
LOOKUP function in VB Macro.
Cells(1, i) = Application.Lookup_
(Cells(2,i), Workbooks("My WorkBook.xls").Names("myTable").ReferstoRange) My Workbook.xls must be open. -- Regards, Tom Ogilvy "Art Du Rea" wrote in message ... Remove NOGI and NOGO for e-mail address (NO Garbage In - NO Garbage Out) Esteemed Group Participants and Lurkers: I can't seem to get the lookup function to execute in a complex macro I am writing. Here is what I am trying to do: Workbook with active sheet with macro: H:\Test\MyTestBook.xls Sheet1 Workbook with lookup source: D:\Work\My WorkBook.xls SheetX Lookup Table is named "myTable" The lookup table works fine, but I can't get it to work inside the macro. I have tried cut and paste and other things, but haven't gotten anything to work. Here is the closest I can come: Dim i As Long i = 7 Cells(1, i) = Application.WorksheetFunction.Lookup_ (Cells(2,i), 'D:\Work\My WorkBook.xls'!myTable) Any suggestions as to how to get this to work? Thank you for any comments, suggestions, or assistance. Blessings in abundance, all the best, and ENJOY! Art Du Rea Carlisle, PA USA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining Lookup function and Sum function | Excel Worksheet Functions | |||
LOOKUP FUNCTION? (LOOKUP VALUE BEING A TIME RENERATED FROM A FORMU | Excel Discussion (Misc queries) | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
how to combine an IF Function with a lookup function to determine | Excel Worksheet Functions | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) |