create function

[Guest]

hi,
i've created a custom function that returns the name of the tab in which the
cell is :

ThisWorksheetName = ThisWorkbook.ActiveSheet.Name

but this is not correct because of the 'ActiveSheet' property. My function
returns the name of the active sheet but not the name of the sheet containing
my formula...

does anyone have any suggestion ?
thanks

 

[Norman Jones]

Hi Luc,

Try:

ThisWorksheetName = Application.Caller.Parent.Name

 

[Frank Kabel]

Hi
for a non VBA solution see:
http://www.xldynamic.com/source/xld.xlFAQ0002.html