How do I link 'tab names' to a cell in Excell spreadsheets

[Guest]

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

 

[Bob Phillips]

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


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

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

 

[Paul B]

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

 

[Guest]

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

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

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