refer to tab info in a cell
 

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

refer to tab info in a cell
 

=RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename")))
--
Gary''s Student - gsnu2007j

refer to tab info in a cell
 

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" wrote in message
...
Excel 2000, Vista
How do you refer to the info on the tab (worksheet name) in a cell in the
worksheet
Thank you,
Bill

refer to tab info in a cell
 

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" wrote in message
...
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" wrote in message
...
Excel 2000, Vista
How do you refer to the info on the tab (worksheet name) in a cell in the
worksheet
Thank you,
Bill

refer to tab info in a cell
 

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

On Sun, 8 Jun 2008 08:56:05 -0400, "bpauley" wrote:

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" wrote in message
...
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" wrote in message
...
Excel 2000, Vista
How do you refer to the info on the tab (worksheet name) in a cell in the
worksheet
Thank you,
Bill

refer to tab info in a cell
 

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

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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

On Sun, 8 Jun 2008 08:56:05 -0400, "bpauley" wrote:

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" wrote in message
...
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" wrote in message
...
Excel 2000, Vista
How do you refer to the info on the tab (worksheet name) in a cell in
the
worksheet
Thank you,
Bill