refer to tab info in a cell

B

bpauley

Excel 2000, Vista
How do you refer to the info on the tab (worksheet name) in a cell in the
worksheet
Thank you,
Bill
 
G

Gary''s Student

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

Ron Coderre

Try this:

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

Does that help?
Post back if you have more questions.

Regards,

Ron
Microsoft MVP - Excel
 
B

bpauley

Gentlemen,
Thank you so much for the quick and efficient assistance. Both formulas
worked well, however, Ron's permitted for changes in the tab name to be
displayed in the cell in the worksheet immediately. Don't know why but it
did. So, that is the formula I am using.
Again thank you both for the assistance.
Bill

Ron Coderre said:
Try this:

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

Does that help?
Post back if you have more questions.

Regards,

Ron
Microsoft MVP - Excel

bpauley said:
Excel 2000, Vista
How do you refer to the info on the tab (worksheet name) in a cell in the
worksheet
Thank you,
Bill
 
G

Gord Dibben

This formula will give you spurious results.

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

See Bob Phillips' site for explanation.

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


Gord Dibben MS Excel MVP

Gentlemen,
Thank you so much for the quick and efficient assistance. Both formulas
worked well, however, Ron's permitted for changes in the tab name to be
displayed in the cell in the worksheet immediately. Don't know why but it
did. So, that is the formula I am using.
Again thank you both for the assistance.
Bill

Ron Coderre said:
Try this:

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

Does that help?
Post back if you have more questions.

Regards,

Ron
Microsoft MVP - Excel

bpauley said:
Excel 2000, Vista
How do you refer to the info on the tab (worksheet name) in a cell in the
worksheet
Thank you,
Bill
 
B

bpauley

Gord,
thanks for the info. Mr Phillips site is a nice resource, thanks for that
also.
Bill

Gord Dibben said:
This formula will give you spurious results.

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

See Bob Phillips' site for explanation.

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


Gord Dibben MS Excel MVP

Gentlemen,
Thank you so much for the quick and efficient assistance. Both formulas
worked well, however, Ron's permitted for changes in the tab name to be
displayed in the cell in the worksheet immediately. Don't know why but it
did. So, that is the formula I am using.
Again thank you both for the assistance.
Bill

Ron Coderre said:
Try this:

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

Does that help?
Post back if you have more questions.

Regards,

Ron
Microsoft MVP - Excel

Excel 2000, Vista
How do you refer to the info on the tab (worksheet name) in a cell in
the
worksheet
Thank you,
Bill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top