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

tthe wrote:
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?

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

"tthe" wrote in message
...
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?