Put Active Worksheet's Name in a Cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

coreymartin@gmail.com - 06 Jan 2006 18:59 GMT

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.

Reply to this Message

uf_gator - 06 Jan 2006 19:08 GMT

While a little complicated...this should do it

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

Reply to this Message

Bob Phillips - 06 Jan 2006 19:12 GMT

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

Signature

HTH

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

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

Reply to this Message