See http://xldynamic.com/source/xld.xlFAQ0002.html

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Ron Coderre" wrote in message
...
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