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.