Sheet name as cell value

  • Thread starter Thread starter Jon
  • Start date Start date
J

Jon

Is there a formula, or "dynamic" method of taking the sheet name an
putting it as a value in the same sheet.

If the sheet name changes, the cell then updates with the new name.

?
 
Hi

=MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,36)


Arvi Laanemets
 
You must log in or register to reply here.

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

Help to create a macro 2
Using text in a cell in a formula 2
problems getting this macro to work 23
sync same cell value in multiple places 2
Sheet Names and Auto-calculation 2
how to write value 1
if statement with vlookup 1
Need Help With Macro to set a value in new sheets 2

Back
Top