How do I copy Tab into a single cell in Excel?

I want to name my Sheet Tab then have that name automatically put in a cell
in Excel. I am using 2003, but would need it to work in 2000 also.

Take a look at http://www.xldynamic.com/source/xld.xlFAQ0002.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"bryantebbe" <[email protected]> wrote in message
news:[email protected]...
> I want to name my Sheet Tab then have that name automatically put in a
cell
> in Excel. I am using 2003, but would need it to work in 2000 also.

Thanks Bob,

I knew it could be done, You were very helpful.

Bryan

"Bob Phillips" wrote:

> Take a look at http://www.xldynamic.com/source/xld.xlFAQ0002.html
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "bryantebbe" <[email protected]> wrote in message
> news:[email protected]...
> > I want to name my Sheet Tab then have that name automatically put in a
> cell
> > in Excel. I am using 2003, but would need it to work in 2000 also.
>
>
>

bryan

=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)

Enter in any cell.

Note: Workbook must have been saved at least once.

For more on this formula and others similar......path and name etc. see Bob
Phillips site.

http://www.xldynamic.com/source/xld.xlFAQ0002.html


Gord Dibben Excel MVP

On Wed, 19 Jan 2005 16:09:01 -0800, "bryantebbe"
<[email protected]> wrote:

>I want to name my Sheet Tab then have that name automatically put in a cell
>in Excel. I am using 2003, but would need it to work in 2000 also.