Good morning Alexandra
AFAIK there isn't a native Excel function that will do this, but you
could write one very simply. This would do the trick:
Function SheetName()
SheetName = ActiveSheet.Name
End Function
Then the formula =Sheetname() would return the sheetname, whilst this
in a cell:
="This sheet is called " & Sheetname()
would return exactly what you requested.
HTH
DominicB
--
dominicb
------------------------------------------------------------------------
dominicb's Profile:
http://www.excelforum.com/member.php...o&userid=18932
View this thread:
http://www.excelforum.com/showthread...hreadid=399701