Hi,

Could anyone tell me , if possible, how to make a sheet name appear in a
selected cell? For example the name of my sheet is Smith, John and I would
like to appear in, say, A1

Thanks,

Ste

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"PH NEWS" wrote in message
...
Hi,

Could anyone tell me , if possible, how to make a sheet name appear in a
selected cell? For example the name of my sheet is Smith, John and I
would
like to appear in, say, A1

Thanks,

Ste

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

Vaya con Dios,
Chuck, CABGx3



"PH NEWS" wrote:

Hi,

Could anyone tell me , if possible, how to make a sheet name appear in a
selected cell? For example the name of my sheet is Smith, John and I would
like to appear in, say, A1

Thanks,

Ste

Much obliged, cheers guys


"CLR" wrote in message
...
=MID(CELL("filename",D1),FIND("]",CELL("filename",D1),1)+1,99)

Vaya con Dios,
Chuck, CABGx3



"PH NEWS" wrote:

Hi,

Could anyone tell me , if possible, how to make a sheet name appear in a
selected cell? For example the name of my sheet is Smith, John and I
would
like to appear in, say, A1

Thanks,

Ste