 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / February 2007Indirect to Named range
I need to link to several slightl;y differing workbooks Using Indirect I can pick up the data where the cells are fixed. However, some data moves around (insert rows) & I want to link to a named range How do I convert the simple link - ='proj1 package.xls'!project (project is name) to an indirect formula This one give #REF error =INDIRECT(CHAR(39)&"["&$A10&"]" &CHAR(39) &"!"&"project") What am I missing? A10 references the workbook name which the user types in Do you realize that Indirect() only works on open WBs? http://tinyurl.com/2mqasg  SignatureHTH, RD ===================================================== Please keep all correspondence within the Group, so all may benefit! ===================================================== I need to link to several slightl;y differing workbooks Using Indirect I can pick up the data where the cells are fixed. However, some data moves around (insert rows) & I want to link to a named range How do I convert the simple link - ='proj1 package.xls'!project (project is name) to an indirect formula This one give #REF error =INDIRECT(CHAR(39)&"["&$A10&"]" &CHAR(39) &"!"&"project") What am I missing? A10 references the workbook name which the user types in Yes, 'fraid so! > Do you realize that Indirect() only works on open WBs? > [quoted text clipped - 9 lines] > =INDIRECT(CHAR(39)&"["&$A10&"]" &CHAR(39) &"!"&"project") > What am I missing? A10 references the workbook name which the user types in |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.