cells and sheets, names

[PH NEWS]

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

 

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[CLR]

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

Vaya con Dios,
Chuck, CABGx3

 

[PH NEWS]

Much obliged, cheers guys

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

Vaya con Dios,
Chuck, CABGx3

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