software

Hi

I would like to display the worksheet name is a cell, is that possible
(how)?

something like =me.name

regards
HenryTry:

=MID(CELL(quot;filenamequot;,A1), FIND(quot;]quot;, CELL(quot;filenamequot;, A1)) 1, 255)

Once the file has been saved
--
Gary''s Studentquot;henryquot; wrote:

gt; Hi
gt;
gt; I would like to display the worksheet name is a cell, is that possible
gt; (how)?
gt;
gt; something like =me.name
gt;
gt; regards
gt; Henry
gt;
gt;
gt;
gt;
gt;

gt;
gt; =MID(CELL(quot;filenamequot;,A1), FIND(quot;]quot;, CELL(quot;filenamequot;, A1)) 1, 255)
gt;
gt; Once the file has been saved
gt; --
gt; Gary''s Student
gt;
Thanks

I'm looking for the sheetname not the workbookname, the sheetname could be
quot;Sheet1quot; or quot;February 2006quot;.cheers
Henry
Hi Henry:

Give it a try. On my system (WIN XP EXCEL XP) it returns the worksheet name
(tab name)

Good Luck
-- Gary's Studentquot;henryquot; wrote:

gt; gt;
gt; gt; =MID(CELL(quot;filenamequot;,A1), FIND(quot;]quot;, CELL(quot;filenamequot;, A1)) 1, 255)
gt; gt;
gt; gt; Once the file has been saved
gt; gt; --
gt; gt; Gary''s Student
gt; gt;
gt; Thanks
gt;
gt; I'm looking for the sheetname not the workbookname, the sheetname could be
gt; quot;Sheet1quot; or quot;February 2006quot;.
gt;
gt;
gt; cheers
gt; Henry
gt;
gt;
gt;