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

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

--
Don Guillett
SalesAid Software

"Stevek" wrote in message
...
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

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

Thanks So Much
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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