How do I use indirect when referring to a named range in a closed

  • Thread starter Thread starter Guest
  • Start date Start date
Can't see all of your title message, but if youre trying to use INDIRECT to
get a result from a closed workbook it doesnt work as far as I know, there
are ways round it though, post more detail,
Regards,
Alan.
 
Not possible, you need VBA for that, Harlan Grove wrote a UDF called Pull and
Laurent Longre has an add-in where the function is named
INDIRECT.EXT

ftp://members.aol.com/hrlngrv/
Look for pull.zip

Laurent Longre has an addin (morefunc)
http://xcell05.free.fr/

the latter comes with help files



Regards,

Peo Sjoblom
 
Hi Alan,

Thanks fior replyinh

I have a workbook which uses indirect to reference a named range in another
workbook. There are quite a few named ranges in quite few closed workbook.
Having them all open would stress the memory of the pc, si I was wondering if
there was a straight forward way of referring to the ranges without getting
#ref! in the cell.

Ed
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set non-continuous PrintArea via Function / Name 0
INDIRECT function to reference a named range 2
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
References to external workbooks 4
Indirect reference causes statistical function to throw up a #NUM! 10
Indirectly us a Named Range 3
Excel EXCEL - Set non-continuous PrintArea via Function / Name 0
Depedent Dropdown and INDIRECT($P$8) with a twist 4

Back
Top