sorru David,
This will do
=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)

I found it some where,

Thank you

"Dilano" wrote:

Dear David
I was looking for the smae solution and I came cross your reply to the gent.
I have used this and it works, but If I have the same cell position in
differnts Active Sheet in one file, all will refer to one Active sheet only,
Let say I past it is a cell in TAB "101" and TAB "102" and so one, when I
check all cells refer to #101 instead of #102, #103 as Active Sheet order, Is
it what it supose to do.

Thank you

"David Billigmeier" wrote:

Hello -
CELL("filename") will output the full path of the sheet and tab you are in
and:

=RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename")))

Will take just the tab name.

Hope that helps


--
David Billigmeier


"SWalton" wrote:

How do I get a cell to reflect the value which lies in a sheet's tab (the
sheet name) without having to manually type it in