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)

"PH NEWS" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

[CLR]

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

[PH NEWS]

Much obliged, cheers guys


"CLR" <[email protected]> wrote in message
news:[email protected]...
> =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
> >
> >
> >