Sheetname

[monor]

I want to show the sheetname in a cell. What formule/funtion to use?

Exampel: The sheet is named "Test". I want this name to appear in cell A1.

[Peo Sjoblom]

The workbook must be saved

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)


--

Regards,

Peo Sjoblom

"monor" <[email protected]> wrote in
message news:[email protected]...
>
> I want to show the sheetname in a cell. What formule/funtion to use?
>
> Exampel: The sheet is named "Test". I want this name to appear in cell
> A1.
>
>
> --
> monor
> ------------------------------------------------------------------------
> monor's Profile:
http://www.excelforum.com/member.php...o&userid=30308
> View this thread: http://www.excelforum.com/showthread...hreadid=499721
>