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)

 

[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]...

 

[David McRitchie]

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