tab names in cells?
 

How can I see the shett tab name in a spreadsheet cell of that sheet?

tab names in cells?
 

Please try this ...

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



*** Please do rate ***



"MIKE" wrote:

How can I see the shett tab name in a spreadsheet cell of that sheet?

tab names in cells?
 

Note, if this formula appears not to work, then save the file first before
using it, then it works fine.

Vaya con Dios,
Chuck, CABGx3



"Naveen" wrote:

Please try this ...

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



*** Please do rate ***



"MIKE" wrote:

How can I see the shett tab name in a spreadsheet cell of that sheet?

tab names in cells?
 

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

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"MIKE" wrote in message
...
How can I see the shett tab name in a spreadsheet cell of that sheet?