... I would like the Worksheet Tab Title to be in Cell A1 too...

[Dr. Darrell]

Is there a function that links the text on the Worksheet Tab to a Cell?

Darrell

[Peo Sjoblom]

One way

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)


--

Regards,

Peo Sjoblom

"Dr. Darrell" <DrDarrell@discussions.microsoft.com> wrote in message
news:D0A70CB9-48BF-4BD6-BA17-3D10F8B1B3DB@microsoft.com...
> Is there a function that links the text on the Worksheet Tab to a Cell?
>
> Darrell

[Dr. Darrell]

Peo:

This seems to be a method to extract text from a string in a given cell. I
don't think it will work with the TAB. (unless the Tab has an address similar
to a cell's address.

"Peo Sjoblom" wrote:

> One way
>
> =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> "Dr. Darrell" <DrDarrell@discussions.microsoft.com> wrote in message
> news:D0A70CB9-48BF-4BD6-BA17-3D10F8B1B3DB@microsoft.com...
> > Is there a function that links the text on the Worksheet Tab to a Cell?
> >
> > Darrell
>
>
>

[Peo Sjoblom]

Why don't you try it

--

Regards,

Peo Sjoblom

"Dr. Darrell" <DrDarrell@discussions.microsoft.com> wrote in message
news:C46AA431-DAA0-49BF-AF6C-009954440374@microsoft.com...
> Peo:
>
> This seems to be a method to extract text from a string in a given cell. I
> don't think it will work with the TAB. (unless the Tab has an address
similar
> to a cell's address.
>
> "Peo Sjoblom" wrote:
>
> > One way
> >
> > =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)
> >
> >
> > --
> >
> > Regards,
> >
> > Peo Sjoblom
> >
> > "Dr. Darrell" <DrDarrell@discussions.microsoft.com> wrote in message
> > news:D0A70CB9-48BF-4BD6-BA17-3D10F8B1B3DB@microsoft.com...
> > > Is there a function that links the text on the Worksheet Tab to a
Cell?
> > >
> > > Darrell
> >
> >
> >

[Dr. Darrell]

I entered my file name: =MID(CELL(Test,A1),FIND("]",CELL(Test,A1))+1,32)

I entered my file name along with it's extension:
=MID(CELL(Test.xls,A1),FIND("]",CELL(Test.xls,A1))+1,32)

I entered my file name along with it's extension and it's path:
=MID(CELL('C':\Documents and Settings\Darrell.Roak.PUMP_EXCH\My
Documents\Test.xls,A1),FIND("]",CELL('C':\Documents and
Settings\Darrell.Roak.PUMP_EXCH\My Documents\Test.xls,A1))+1,32)

The result was the same: #NAME (formular result = volitile)

My worksheet Tab name is "Test Tab"

Am I supposed to substitute something for "]" ?



"Peo Sjoblom" wrote:

> Why don't you try it
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> "Dr. Darrell" <DrDarrell@discussions.microsoft.com> wrote in message
> news:C46AA431-DAA0-49BF-AF6C-009954440374@microsoft.com...
> > Peo:
> >
> > This seems to be a method to extract text from a string in a given cell. I
> > don't think it will work with the TAB. (unless the Tab has an address
> similar
> > to a cell's address.
> >
> > "Peo Sjoblom" wrote:
> >
> > > One way
> > >
> > > =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)
> > >
> > >
> > > --
> > >
> > > Regards,
> > >
> > > Peo Sjoblom
> > >
> > > "Dr. Darrell" <DrDarrell@discussions.microsoft.com> wrote in message
> > > news:D0A70CB9-48BF-4BD6-BA17-3D10F8B1B3DB@microsoft.com...
> > > > Is there a function that links the text on the Worksheet Tab to a
> Cell?
> > > >
> > > > Darrell
> > >
> > >
> > >
>
>
>

[Dave Peterson]

Don't make any changes with Peo's original formula. Just copy and paste
directly to the formula bar for that cell.



Dr. Darrell wrote:
>
> I entered my file name: =MID(CELL(Test,A1),FIND("]",CELL(Test,A1))+1,32)
>
> I entered my file name along with it's extension:
> =MID(CELL(Test.xls,A1),FIND("]",CELL(Test.xls,A1))+1,32)
>
> I entered my file name along with it's extension and it's path:
> =MID(CELL('C':\Documents and Settings\Darrell.Roak.PUMP_EXCH\My
> Documents\Test.xls,A1),FIND("]",CELL('C':\Documents and
> Settings\Darrell.Roak.PUMP_EXCH\My Documents\Test.xls,A1))+1,32)
>
> The result was the same: #NAME (formular result = volitile)
>
> My worksheet Tab name is "Test Tab"
>
> Am I supposed to substitute something for "]" ?
>
> "Peo Sjoblom" wrote:
>
> > Why don't you try it
> >
> > --
> >
> > Regards,
> >
> > Peo Sjoblom
> >
> > "Dr. Darrell" <DrDarrell@discussions.microsoft.com> wrote in message
> > news:C46AA431-DAA0-49BF-AF6C-009954440374@microsoft.com...
> > > Peo:
> > >
> > > This seems to be a method to extract text from a string in a given cell. I
> > > don't think it will work with the TAB. (unless the Tab has an address
> > similar
> > > to a cell's address.
> > >
> > > "Peo Sjoblom" wrote:
> > >
> > > > One way
> > > >
> > > > =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)
> > > >
> > > >
> > > > --
> > > >
> > > > Regards,
> > > >
> > > > Peo Sjoblom
> > > >
> > > > "Dr. Darrell" <DrDarrell@discussions.microsoft.com> wrote in message
> > > > news:D0A70CB9-48BF-4BD6-BA17-3D10F8B1B3DB@microsoft.com...
> > > > > Is there a function that links the text on the Worksheet Tab to a
> > Cell?
> > > > >
> > > > > Darrell
> > > >
> > > >
> > > >
> >
> >
> >

--

Dave Peterson