I think you'll be better off including a cell reference:

=cell("Filename",a1)

If you don't include that last reference, then this formula will evaluate to the
workbook that was active during the last calculation.

If you open two workbooks and put:
=cell("Filename")
in A1 of a worksheet in each workbook
then use window|arrange|tiled
to see both worksheets,
you'll see the difference.



JENNYC wrote:

thank you! Perfect!! :)

--
JENNYC
------------------------------------------------------------------------
JENNYC's Profile: http://www.excelforum.com/member.php...o&userid=19579
View this thread: http://www.excelforum.com/showthread...hreadid=479124

--

Dave Peterson