How to reference a worksheet name
 

How do I call the name of a worksheet in a specified cell?


--
craftcenter
------------------------------------------------------------------------
craftcenter's Profile: http://www.excelforum.com/member.php...o&userid=33001
View this thread: http://www.excelforum.com/showthread...hreadid=528256

How to reference a worksheet name
 

=MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,100)


"craftcenter" wrote:


How do I call the name of a worksheet in a specified cell?


--
craftcenter
------------------------------------------------------------------------
craftcenter's Profile: http://www.excelforum.com/member.php...o&userid=33001
View this thread: http://www.excelforum.com/showthread...hreadid=528256

How to reference a worksheet name
 

Hello craftcenter,

Or download/install www.asap-utilities.com and use ...

=SHEETNAME()

HTH

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM


"craftcenter"
wrote in message
...

How do I call the name of a worksheet in a specified cell?


--
craftcenter
------------------------------------------------------------------------
craftcenter's Profile:
http://www.excelforum.com/member.php...o&userid=33001
View this thread: http://www.excelforum.com/showthread...hreadid=528256

How to reference a worksheet name
 

or if you want to reference a cell in another worksheet
=sheet3!B4
='Big Sheet'!B4