I have a workbook with several worksheets. In each worksheet, cell H1
is the TABNAME:
=MID(CELL("filename",H1),FIND("]",CELL("filename",H1))+1,255).

I have a Summary sheet where I want to reference each sheet. Since a
user can change the tab names, how can I show the TEXT VALUE in cell H1
and not the formula?

Thanks in advance for any help!


--
tbitler
------------------------------------------------------------------------
tbitler's Profile: http://www.excelforum.com/member.php...o&userid=25538
View this thread: http://www.excelforum.com/showthread...hreadid=389744