software

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

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

--

HTH

RP
(remove nothere from the email address if mailing direct)quot;dingy101quot; gt; wrote in message
...
gt; Is it possible to have a cell auto fill with the sheet name.
gt;
gt; I want to use the sheet name in formulas across multiple sheets.
gt;
gt; Thanks
gt; Gary
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

quot;dingy101quot; gt; wrote in message
...
gt; Is it possible to have a cell auto fill with the sheet name.
gt;
gt; I want to use the sheet name in formulas across multiple sheets.
gt;
gt; Thanks
gt; Gary