Alexandra,
Excel can do what you want. Put in any cell:
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,30)
Jack Sons
The Netherlands
"Alexandra" schreef
in bericht ...
Hello,
I would like to know if there's a function or a macro to put the name
of the current sheet in a cell like
="this sheet is called"&<function that returns the name of the sheet
so that if a sheet's name is "kaput" it should appear "this sheet is
called kaput"
Tks
Alexandra
--
Alexandra
------------------------------------------------------------------------
Alexandra's Profile:
http://www.excelforum.com/member.php...o&userid=26707
View this thread: http://www.excelforum.com/showthread...hreadid=399701