how do i name a excel worksheet and make it appear in cell a1

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i want the name of the worksheet to appear in cell a1, and for it to change
if i change the sheet name. is this possible?
 
In A1 enter:
=MID(CELL("Filename"),FIND("]",CELL("Filename"))+1,255)

Hope this helps
Rowan
 
Hi!

The file has to have already been saved. In other words, if you open a brand
new file and enter this formula, it won't work (it'll return an error) until
you name the file and save it.

Enter this formula in A1:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

Biff
 
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

How do I use the text content of a cell as a worksheet reference? 9
Inerting name of current worksheet into fuction 11
Vlookup and return sheet name also 2
Using names referencing a cell in another workbook 2
Conditional Sum across WORKSHEET 6
Reference(s) to worksheets for building graphs 4
sum accross worksheets using names 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Back
Top