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

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

--

HTH

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


"dingy101" <dingy101@discussions.microsoft.com> wrote in message
news:6807CA66-B47E-4889-9D24-01D7F16A9504@microsoft.com...
> 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

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" <dingy101@discussions.microsoft.com> wrote in message
news:6807CA66-B47E-4889-9D24-01D7F16A9504@microsoft.com...
> 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