Tab name in a cell?
 

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.

Tab name in a cell?
 

John, have a look here, http://www.xldynamic.com/source/xld.xlFAQ0002.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"JHJ" wrote in message
...
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.

Tab name in a cell?
 

=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.

Tab name in a cell?
 

That's good info. Thanks!

"Paul B" wrote:

John, have a look here, http://www.xldynamic.com/source/xld.xlFAQ0002.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"JHJ" wrote in message
...
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.

Tab name in a cell?
 

Thanx !

"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.

Tab name in a cell?
 

Your welcome
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"JHJ" wrote in message
...
That's good info. Thanks!

"Paul B" wrote:

John, have a look here,
http://www.xldynamic.com/source/xld.xlFAQ0002.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"JHJ" wrote in message
...
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.

Tab name in a cell?
 

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.

Tab name in a cell?
 

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.