Tabname function

[Lythamlatic]

I created a simple function as follows:

Public Function TabName() as string

TabName = ActiveSheet.Name

End Function

This works as I would expect, except it doesn't update when the worksheet tab name is changed - the only way to get it to update is to enter-then-exit edit-mode in the cell containing =TabName()

Can anyone explain why this is, and what I can do to make it more dynamic?

Thanks

 

[Artik]

At the beginning of the function, add:

Application.Volatile

Artik