Hi
for a non VBA solution see:
http://www.xldynamic.com/source/xld.xlFAQ0002.html
--
Regards
Frank Kabel
Frankfurt, Germany
Luc M wrote:
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