refer to tab info in a cell

  • Thread starter Thread starter bpauley
  • Start date Start date
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
 
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
 
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
Click to expand...
Click to expand...
 
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
Click to expand...
Click to expand...
Click to expand...
 
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top