Hi, thanks.

I have tried Laurent Longre's MOREFUNC.XLL using indirect.ext

Here is my formula
=INDIRECT.EXT("'C:\folder\["&I2&".xls]Book1!$Y$12")

However, this returns a #VALUE!

Is this the correct way to use the formula?

Thanks


--
kestrel
------------------------------------------------------------------------
kestrel's Profile: http://www.excelforum.com/member.php...o&userid=19082
View this thread: http://www.excelforum.com/showthread...hreadid=552254