Put Active Worksheet's Name in a Cell

[coreymartin]

Is there anyway to put the currently active worksheet's name in a cell?
Not the filename of the whole workbook, just the currently selected
worksheet.

Thanks for your help.

 

[uf_gator]

While a little complicated...this should do it

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

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.xlFAQ0002.html

--

HTH

RP
(remove nothere from the email address if mailing direct)