How to reference a worksheet name

[craftcenter]

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

[Duke Carey]

=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
>
>

[Zack Barresse]

Hello craftcenter,

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

=SHEETNAME()

HTH

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


"craftcenter" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

[David McRitchie]

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