cell display sheet name

[dingy101]

Is it possible to have a cell auto fill with the sheet name.

I want to use the sheet name in formulas across multiple sheets.

Thanks
Gary

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.xlFAQ0002.html

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Bernard Liengme]

Here is a UDF that does that
Function mysheet()
mysheet = Application.ActiveSheet.Name
End Function

Open VB Editor with ALT+F11
In the project window (generally to left) select the worksheet - look for
VBAProject(YourFIleName)
Use Insert|Module
Copy or retype my function
In Excel enter =mysheet()
happy new year