How do I make a cell = the sheet name?
 

How do I make a cell only display the name of the sheet? without writing e.g
"sheet1"
Is there a formula such as =sheetname ?

How do I make a cell = the sheet name?
 

File must be saved at least once for the formula to work...

Try in any cell
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)

"adam" wrote:

How do I make a cell only display the name of the sheet? without writing e.g
"sheet1"
Is there a formula such as =sheetname ?

How do I make a cell = the sheet name?
 

Brilliant works like a charm, thanks for your help!

How do I make a cell = the sheet name?
 

You are most welcome. Thanks for the feedback.

Try to get into the habit of using Google... it will save you time and teach
new things...

"adam" wrote:


Brilliant works like a charm, thanks for your help!