Hi,
In cell C4 in the sheet1, type the following formula
=cell("filename")
Now save and close the worksheet and reopen it.
In the cell in which you want the particular worksheet name type the
following array formula (Ctrl+Shift+Enter),
"This sheet is called " &MID(C4,MATCH("]",MID($C$4,ROW(1:200),1),0)+1,15)
Regards,
Ashish Mathur
"Alexandra" wrote:
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