UDF Function to refer to the Sheet Name

[YasserKhalil]

Hi everybody
I have a UDF function which returns the sheet name
The problem is that when renaming the sheet it doesn't change until I click double in the cell which contains the function
Is there a way to update the result??


Function SheetName()
SheetName = ActiveSheet.Name
End Function

[GTO]

Have you tried:


=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)

[Bob Phillips]

Call it with

=SheetName()&TEXT(NOW(),"")

[YasserKhalil]

Thanks Mr. Mark
Good formula
---
Mr. xld
A very good trick and it solves the problem
But I hope to find a better solution as I encountered such problem in another UDF function

[mbarron]

You can add Application.Volatile True to your code as well.
Function SheetName()
Application.Volatile True
SheetName = ActiveSheet.Name
End Function

[YasserKhalil]

Mr. mbarron
That's the point ..
Excellent solution
But please could you explain the first line of the code
Application.Volatile True

[GTO]

Call it with

=SheetName()&TEXT(NOW(),"")

That's neat!