Jacob,

Try the following formula

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

The file must have been saved for this to work. It won't work if
the file has never been saved.


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


"jacob" wrote in message
...
I need to find out how to place the name of the current tab or
active tab in
a cell How do i do this. It is easy to do in a Header of Footer
but i want to
be able to do it in a cell.

Thanks!!!