Put Active Worksheet's Name in a Cell

C

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.
 
U

uf_gator

While a little complicated...this should do it

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