See

http://www.mcgimpsey.com/excel/formu..._function.html


..In article ,
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