Steve

Function ShtName()
Application.Volatile
ShtName = ActiveSheet.Name
End Function


Gord Dibben MS Excel MVP

On Thu, 14 Dec 2006 10:21:00 -0600, "Stevek" wrote:

Hello All,
I have a little function that places the sheet name in a cell. But the
function will not update automaticly when the sheet name is changed or when
I press F9. Any help would be appreciated.
------------------------------------
Function ShtName()
ShtName = ActiveSheet.Name
End Function
------------------------------------
TIA
Steve