WOW!! I'm not sure how you did it but it works perfectly. I am trying to
understand how the formula but it's beyond me. Thanks you very much!!
Helen

"Chip Pearson" wrote:

Try the following formula:

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

The workbook must have been saved to disk for this to work. Note
that you need the word "filename" in the formula, as it is
written, NOT the actual filename. You can replace the A1 with any
cell you like. It doesn't matter which cell you use, just so long
as it is on the same worksheet.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"HR Duvall" wrote in message
...
I am trying to find an easy way to insert the tab name in the
body of the
worksheet. I know in headers & footers you can use &[TAB] but
I can't seem
to make that work in the worksheet. Any help will be greatly
appreciated.