View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Saintsman Saintsman is offline
external usenet poster
 
Posts: 81
Default 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