How do I make a cell = the sheet name?

  • Thread starter Thread starter adam
  • Start date Start date
A

adam

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 ?
 
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)
 
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)
 
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...
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Get sheet names 9
Refer to sheet name specified in other cell 2
Need Help With Macro to set a value in new sheets 2
Use a sheet name in a formula 7
How do I change the Sheet name without updating formulas? 3
reference to an external file 6
Referencing the same cell on multiple sheets 1
Code to format cells on several worksheets 2

Back
Top