Worksheet Name in a Cell
 

I hope this is as easy I thyink it might be. Is there a way to have the name
of an individual worksheet appear in one of the cells in the same sheet?

Thanks.

Worksheet Name in a Cell
 

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

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Jack Taylor" wrote in message
...
I hope this is as easy I thyink it might be. Is there a way to have the
name
of an individual worksheet appear in one of the cells in the same sheet?

Thanks.

Worksheet Name in a Cell
 

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99)

Vaya con Dios,
Chuck, CABGx3



"Jack Taylor" wrote:

I hope this is as easy I thyink it might be. Is there a way to have the name
of an individual worksheet appear in one of the cells in the same sheet?

Thanks.