You're welcome. Thanks for the feedback!

Biff

"LPatt" wrote in message
...
Thank you it worked perfectly!!

"Biff" wrote:

Try this:

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

The file must already exist. In other words, it must have already been
saved
and given a name.

Biff

"LPatt" wrote in message
...
Is there a formula to make cell A5 show the name of the tab for that
sheet
automatically?

Thank you for any help