software

How can I place the current worksheet name into cell A1?
See

www.mcgimpsey.com/excel/formu..._function.htmlIn article gt;,
quot;Patrick Simondsquot; gt; wrote:

gt; How can I place the current worksheet name into cell A1?

The WB *must* be saved for this to return the sheet name.

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

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

quot;Patrick Simondsquot; gt; wrote in message
...
How can I place the current worksheet name into cell A1?

Try this

=MID(CELL(quot;filenamequot;,A1),SEARCH(quot;]quot;,CELL(quot;filenamequot;,A1),1) 1,LEN(CELL(quot;filenamequot;,A1) )-SEARCH(quot;]quot;,CELL(quot;filenamequot;,A1)))quot;Patrick Simondsquot; gt; wrote in message
...
gt; How can I place the current worksheet name into cell A1?
gt;
See www.xldynamic.com/source/xld.xlFAQ0002.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Patrick Simondsquot; gt; wrote in message
...
gt; How can I place the current worksheet name into cell A1?
gt;
gt;