Cell value = tab name?
 

is there a formula to put into a cell that will display the tab name in
the cell?
Thanks!


--
foxgguy2005
------------------------------------------------------------------------
foxgguy2005's Profile: http://www.excelforum.com/member.php...o&userid=23663
View this thread: http://www.excelforum.com/showthread...hreadid=379983

Try:

=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1) )-FIND("]",CELL("filename",A1)))

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=379983

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

--
HTH

Bob Phillips

"foxgguy2005"
wrote in message
...

is there a formula to put into a cell that will display the tab name in
the cell?
Thanks!


--
foxgguy2005
------------------------------------------------------------------------
foxgguy2005's Profile:
http://www.excelforum.com/member.php...o&userid=23663
View this thread: http://www.excelforum.com/showthread...hreadid=379983