How do I insert the sheet name into a cell

[Jelly]

I cannot find a function that allows me automatically to insert the sheet
name into a cell within the sheet.
Grateful for any help.

 

[Bob Phillips]

Take a look at
http://www.xldynamic.com/source/xld.xlFAQ0002.html

 

[Ryan Poth]

Jelly,

Not exactly what you want, but it might get you closer.

=CELL("filename")

will return the path, file, and sheet names in one. You can then use a
string function to extract the sheet name from there.

HTH,
Ryan

 

[Jelly]

That's really useful. I would like to add the sh.name function you describe
but cannot find book.xlt or any similar Excel template (I'm running Office
XP). Can please let me know how/where I can do this?
Many thanks

 

[Bob Phillips]

Jelly,

There is a problem with your formula. Take a look at the link I posted to
see what and why.

 

[Bob Phillips]

Jelly,

Book.xlt does not necessarily exist and if it does, might be in different
locations on different machines.

If you don't have one, new a standard Excel workbook, make the changes you
want, and save it as an Excel template named Book.xlt.

Save it to the Office\XLStart directory, and check that that works.

 

[Bob Phillips]

Sorry, meant Ryan

--

HTH

RP

Jelly,

There is a problem with your formula. Take a look at the link I posted to
see what and why.

--

HTH

RP

 

[Jelly]

Dear Bob
Thanks very much, I will give it a go.
Jelly