If you put my posted formula in more than one sheet.....
all formulas will return the same value on all sheets (unless you recalculate)

To force them to show the correct sheet names,
try this, instead
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)&T(NOW())

***********
Regards,
Ron

XL2002, WinXP


"Ron Coderre" wrote:

Steve....


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

You can just copy the formula directly from the post and paste it into the
formula bar.

"filename" is not the name of your file.
It's the Info_Type to be returned by the CELL function.
(I should have been more clear.)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Steve" wrote:

I'm getting a #Value!

=MID(CELL("Master"),FIND(")",CELL("Master"))+1,255 )

"Ron Coderre" wrote:

Try this:

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

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Steve" wrote:

Can I have the tab name show in a specific cell, whereas when the tab name is
changed, the cell reults also change ? And if so, is it simply a formula?

Thanks,

Steve