| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Vlookup External Reference
Any help would be appreciated
Lookup_Data = WorksheetFunction.VLookup(Model, RngLookup, 2, False) I want to use RngLookup for a range eventually in an .xla however I cant seem to get an external reference to an open file when it is not the active workbook In other words is it possible to use that function referencing an open file that is not the activesheet? if so I need the syntax Thank you Jeff -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| External reference to a Column | Excel Worksheet Functions | |||
| External Reference in Vlookup | Excel Discussion (Misc queries) | |||
| sumproduct external reference#2 | Excel Worksheet Functions | |||
| sumproduct external reference | Excel Worksheet Functions | |||
| External Reference | Excel Discussion (Misc queries) | |||
Threaded Mode
