I have received a path to link the tab name to a cell in Excel, however, it
repeats for each sheet. I would like each sheet to have its own tab name in
a cell. What I am using that does not do this is:
=RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH(")",CELL("filename")))

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


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Kathy H. H." <Kathy H. wrote in message
...
I have received a path to link the tab name to a cell in Excel, however,
it
repeats for each sheet. I would like each sheet to have its own tab name
in
a cell. What I am using that does not do this is:

=RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH(")",CELL("filename")))

Kathy, try this,

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

file must be saved first



You may also want to have a look at
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


"Kathy H. H." <Kathy H. wrote in message
...
I have received a path to link the tab name to a cell in Excel, however, it
repeats for each sheet. I would like each sheet to have its own tab name
in
a cell. What I am using that does not do this is:
=RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH(")",CELL("filename")))

THANK YOU, PAUL B! IT WORKS LIKE A CHARM! KATHY H.H.

"Paul B" wrote:

Kathy, try this,

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

file must be saved first



You may also want to have a look at
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


"Kathy H. H." <Kathy H. wrote in message
...
I have received a path to link the tab name to a cell in Excel, however, it
repeats for each sheet. I would like each sheet to have its own tab name
in
a cell. What I am using that does not do this is:
=RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH(")",CELL("filename")))