I want to write a function that will return the name of the sheet where the function is entered. ie: I want to enter "=sheetname()" into cell A2 of "Sheet1" and have cell A2 display "Sheet1".

When I try the following I get the #Value error.

Function sheetname()
ActiveSheet.name
End Function

Am I missing something in regards to how functions return values? Do I need to use a variable and return the variable?