... 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

[Dr. Darrell]

I copied and pasted the formular as typed by Peo and I got the same result:
"#NAME"

Darrell

"Dave Peterson" wrote:

> 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
>

[Dave Peterson]

Did you use Peo's original formula?

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

I bet you changed it slightly.

Dr. Darrell wrote:
>
> I copied and pasted the formular as typed by Peo and I got the same result:
> "#NAME"
>
> Darrell
>
> "Dave Peterson" wrote:
>
> > 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
> >

--

Dave Peterson

[David]

=?Utf-8?B?RHIuIERhcnJlbGw=?= wrote

> I copied and pasted the formular as typed by Peo and I got the same
> result: "#NAME"
>
> Darrell

I seem to recall you have to save the file before the formula takes effect.

--
David

[Dave Peterson]

But I get a #value! error if the workbook wasn't saved.

David wrote:
>
> =?Utf-8?B?RHIuIERhcnJlbGw=?= wrote
>
> > I copied and pasted the formular as typed by Peo and I got the same
> > result: "#NAME"
> >
> > Darrell
>
> I seem to recall you have to save the file before the formula takes effect.
>
> --
> David

--

Dave Peterson

[David]

Dave Peterson wrote

> But I get a #value! error if the workbook wasn't saved.

I'll have to bow to your considerably greater experience in these matters.
I just didn't see any reference to saving the file in this thread.

--
David

[Dave Peterson]

It wasn't greater experience--I just copied the formula into a new workbook and
saw the results <bg>.

David wrote:
>
> Dave Peterson wrote
>
> > But I get a #value! error if the workbook wasn't saved.
>
> I'll have to bow to your considerably greater experience in these matters.
> I just didn't see any reference to saving the file in this thread.
>
> --
> David

--

Dave Peterson

[TulsaCPA]

Folks,

This is an old discussion that I picked on, but if you do copy & paste the original formula, it works great.

Visit me when in Tulsa,
TulsaCPA