Function Update

[Stevek]

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.

 

[Don Guillett]

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

 

[Gord Dibben]

Steve

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


Gord Dibben MS Excel MVP

 

[Stevek]

Thanks So Much

Steve

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


Gord Dibben MS Excel MVP