MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Inserting worksheet name into a cell

Posted by Janet on October 12, 1999 3:04 AM

How can I insert the name of a worksheet into a cell, so that if the name is changed, the cell automatically updates?

Posted by Chris on October 12, 1999 5:32 AM


You can do this with a custom function. Copy the following function to a module sheet within the workbook:

Function SheetName()
SheetName = ActiveSheet.Name
End Function

You then can type the following formula in any cell on the sheet.


This recalcs like any other formula would.


Posted by Rudolf on April 12, 0100 7:02 AM


There is indeed a simple way to get the filename into a cell:

Posted by Rudolf on April 12, 0100 7:05 AM

the formula is: =cell("filename";a1)

excuse for sending it in 2 parts

Posted by brad gardiner on May 30, 0100 9:00 AM

I'm trying to put the worksheet name in a cell to be used in a formula and the code above will not work for me. I'm using Excel 2000. Any ideas?


Posted by Gary Ford on February 10, 0100 10:39 AM


I am using 97 and whilst the function you specify works OK first time I find that it does not introduce changes automatically. Is there an alternative of making this function a global one (or something similar) rather than linking it to a specific sheet?



Posted by mads on June 21, 0100 2:25 PM

Try :-

PS. Rather than add messages to very old questions, you will be more likely to receive replies if you add a new question. I just happened to notice your message when looking for something else.