How to use indirect function?

[Eric]

Does anyone have any suggestions on how to use Indirect function to retrieve
the value 2318 from cell A1 for following formula in cell B1
='C:\folder\2318\[file.xls]sheet'!M$15 in cell B1
Thanks in advance for any suggestions
Eric

 

[Sheeloo]

=INDIRECT(B1)

To make sure that the string in B1 is correct put a = before it... once it
returns the value in the cell it refers to... delete = and use the INDIRECT
formula

 

[Max]

INDIRECT won't work to retrieve stuff from closed books, which is what you're
trying to do. I'd just try using a couple of Edit > Replaces to change the
link formulas en-masse.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik