Home |
Search |
Today's Posts |
#1
|
|||
|
|||
create function
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 |
#2
|
|||
|
|||
Hi Luc,
Try: ThisWorksheetName = Application.Caller.Parent.Name --- Regards, Norman "Luc M" wrote in message ... 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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to list unique values | Excel Worksheet Functions | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
How do I create a multi formula IF function in Excel? | Excel Worksheet Functions | |||
change function variable prompts?? | Excel Worksheet Functions |