software

How do I call the name of a worksheet in a specified cell?--
craftcenter
------------------------------------------------------------------------
craftcenter's Profile: www.excelforum.com/member.php...oamp;userid=33001
View this thread: www.excelforum.com/showthread...hreadid=528256=MID(CELL(quot;filenamequot;,$A$1),FIND(quot;]quot;,CELL(quot;filenamequot;,$A$1)) 1,100)quot;craftcenterquot; wrote:

gt;
gt; How do I call the name of a worksheet in a specified cell?
gt;
gt;
gt; --
gt; craftcenter
gt; ------------------------------------------------------------------------
gt; craftcenter's Profile: www.excelforum.com/member.php...oamp;userid=33001
gt; View this thread: www.excelforum.com/showthread...hreadid=528256
gt;
gt;

Hello craftcenter,

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

=SHEETNAME()

HTH

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAMquot;craftcenterquot; gt;
wrote in message
...
gt;
gt; How do I call the name of a worksheet in a specified cell?
gt;
gt;
gt; --
gt; craftcenter
gt; ------------------------------------------------------------------------
gt; craftcenter's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33001
gt; View this thread: www.excelforum.com/showthread...hreadid=528256
gt;
or if you want to reference a cell in another worksheet
=sheet3!B4
='Big Sheet'!B4