Indirect to Named range

[Guest]

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

 

[RagDyeR]

Do you realize that Indirect() only works on open WBs?

http://tinyurl.com/2mqasg

--

HTH,

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

 

[Guest]

Yes, 'fraid so!