software

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 www.xldynamic.com/source/xld.xlFAQ0002.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;PH NEWSquot; gt; wrote in message
...
gt; Hi,
gt;
gt; Could anyone tell me , if possible, how to make a sheet name appear in a
gt; selected cell? For example the name of my sheet is Smith, John and I
would
gt; like to appear in, say, A1
gt;
gt; Thanks,
gt;
gt; Ste
gt;
gt;
=MID(CELL(quot;filenamequot;,D1),FIND(quot;]quot;,CELL(quot;filenamequot;,D1),1) 1,99)

Vaya con Dios,
Chuck, CABGx3
quot;PH NEWSquot; wrote:

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

Much obliged, cheers guysquot;CLRquot; gt; wrote in message
news
gt; =MID(CELL(quot;filenamequot;,D1),FIND(quot;]quot;,CELL(quot;filenamequot;,D1),1) 1,99)
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;PH NEWSquot; wrote:
gt;
gt; gt; Hi,
gt; gt;
gt; gt; Could anyone tell me , if possible, how to make a sheet name appear in a
gt; gt; selected cell? For example the name of my sheet is Smith, John and I
would
gt; gt; like to appear in, say, A1
gt; gt;
gt; gt; Thanks,
gt; gt;
gt; gt; Ste
gt; gt;
gt; gt;
gt; gt;