cell display sheet name
 

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

cell display sheet name
 

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

--

HTH

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


"dingy101" wrote in message
...
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

cell display sheet name
 

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

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"dingy101" wrote in message
...
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