Interesting....thanks for pointing that out Gord.

Vaya con Dios,
Chuck, CABGx3


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Chuck

Have a read at Bob Phillips' site about the dangers of not adding a cell
reference in your formula.

http://www.xldynamic.com/source/xld.xlFAQ0002.html


Gord Dibben MS Excel MVP


On Fri, 13 Oct 2006 11:19:01 -0700, CLR
wrote:

=MID(CELL("filename"),FIND("]",CELL("filename"),1)+1,99)

Vaya con Dios,
Chuck, CABGx3




"JHJ" wrote:

Is there a way to insert a tab name - or the file name - into a cell? I
know
that I can put either in the header or footer.
Thanx,
John J.