software

can I automatically bring a tab's name into a worksheet?

Thanks.

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

Vaya con Dios,
Chuck, CABGx3
quot;MPquot; wrote:

gt; can I automatically bring a tab's name into a worksheet?
gt;
gt; Thanks.

If the workbook has been saved you can use this

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

the reference to A1 does not mean anything in this case, you just need a
cell address as a part of this function, any will do

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
quot;It is a good thing to follow the first law of holes;
if you are in one stop digging.quot; Lord Healeyquot;MPquot; gt; wrote in message
...
gt; can I automatically bring a tab's name into a worksheet?
gt;
gt; Thanks.
Thanks. I appreciate your help!

quot;CLRquot; wrote:

gt; =MID(CELL(quot;filenamequot;,A1),FIND(quot;]quot;,CELL(quot;filenamequot;,A1),1) 1,99)
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;MPquot; wrote:
gt;
gt; gt; can I automatically bring a tab's name into a worksheet?
gt; gt;
gt; gt; Thanks.

Thanks. I appreciate your help!

quot;CLRquot; wrote:

gt; =MID(CELL(quot;filenamequot;,A1),FIND(quot;]quot;,CELL(quot;filenamequot;,A1),1) 1,99)
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;MPquot; wrote:
gt;
gt; gt; can I automatically bring a tab's name into a worksheet?
gt; gt;
gt; gt; Thanks.