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