Hi,
When I use the indirect.ext function it works fine until I recalculate the
workbook. When I do so, it shows an error value
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Jacob Skaria" wrote in message
...
You can download an add-in called Morefunc it has a function called
INDIRECT.EXT which will work if the source book is closed
Refer
http://xcell05.free.fr/morefunc/english/index.htm
If this post helps click Yes
---------------
Jacob Skaria
"Kash" wrote:
But for INDIRECT, other file should be open right? But, how to go if file
is
closed?