software

I need to find out how to place the name of the current tab or active tab in
a cell How do i do this. It is easy to do in a Header of Footer but i want to
be able to do it in a cell.

Thanks!!!

Jacob,

Try the following formula

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

The file must have been saved for this to work. It won't work if
the file has never been saved.--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;jacobquot; gt; wrote in message
...
gt;I need to find out how to place the name of the current tab or
gt;active tab in
gt; a cell How do i do this. It is easy to do in a Header of Footer
gt; but i want to
gt; be able to do it in a cell.
gt;
gt; Thanks!!!
=RIGHT(CELL(quot;filenamequot;,A1),LEN(CELL(quot;filenamequot;,A1) )-FIND(quot;]quot;,CELL(quot;filenamequot;,A1)))

you need to have saved the file at least once before it will work.

quot;jacobquot; wrote:

gt; I need to find out how to place the name of the current tab or active tab in
gt; a cell How do i do this. It is easy to do in a Header of Footer but i want to
gt; be able to do it in a cell.
gt;
gt; Thanks!!!

Thanks guys!!!!!!!!!!!!!!!!!!11

quot;Slothquot; wrote:

gt; =RIGHT(CELL(quot;filenamequot;,A1),LEN(CELL(quot;filenamequot;,A1) )-FIND(quot;]quot;,CELL(quot;filenamequot;,A1)))
gt;
gt; you need to have saved the file at least once before it will work.
gt;
gt; quot;jacobquot; wrote:
gt;
gt; gt; I need to find out how to place the name of the current tab or active tab in
gt; gt; a cell How do i do this. It is easy to do in a Header of Footer but i want to
gt; gt; be able to do it in a cell.
gt; gt;
gt; gt; Thanks!!!