Sometimes I want to see the filename in a cell - not only in header or
footer on print.

I use this function

=CELL("filnamn";$A$1)

Sorry my version of Excel is in Swedish - please check help for exact
way of writing in your language.

This function give me this info in the cell

L:\Lissu 2006\[Prislista.xls]Blad3

Path - filename - sheet name

Hope this helps!

Lissu


--
Lissu
------------------------------------------------------------------------
Lissu's Profile: http://www.excelforum.com/member.php...o&userid=34431
View this thread: http://www.excelforum.com/showthread...hreadid=543897