=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1) )-FIND("]",CELL("filename",A1)))

you need to have saved the file at least once before it will work.

"jacob" wrote:

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!!!