Indirect 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

Indirect to Named range
 

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!
================================================== ===

"Saintsman" wrote in message
...
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

Indirect to Named range
 

Yes, 'fraid so!

"RagDyeR" wrote:

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!
================================================== ===

"Saintsman" wrote in message
...
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