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

T

tthe

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?
 
R

Rowan Drummond

In A1 enter:
=MID(CELL("Filename"),FIND("]",CELL("Filename"))+1,255)

Hope this helps
Rowan
 
B

Biff

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
 
Top