Home |
Search |
Today's Posts |
#1
|
|||
|
|||
... I would like the Worksheet Tab Title to be in Cell A1 too...
Is there a function that links the text on the Worksheet Tab to a Cell?
Darrell |
#2
|
|||
|
|||
... I would like the Worksheet Tab Title to be in Cell A1 too...
One way
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32) -- Regards, Peo Sjoblom "Dr. Darrell" wrote in message ... Is there a function that links the text on the Worksheet Tab to a Cell? Darrell |
#3
|
|||
|
|||
... I would like the Worksheet Tab Title to be in Cell A1 too.
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" wrote in message ... Is there a function that links the text on the Worksheet Tab to a Cell? Darrell |
#4
|
|||
|
|||
... I would like the Worksheet Tab Title to be in Cell A1 too.
Why don't you try it
-- Regards, Peo Sjoblom "Dr. Darrell" wrote in message ... 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" wrote in message ... Is there a function that links the text on the Worksheet Tab to a Cell? Darrell |
#5
|
|||
|
|||
... I would like the Worksheet Tab Title to be in Cell A1 too.
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" wrote in message ... 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" wrote in message ... Is there a function that links the text on the Worksheet Tab to a Cell? Darrell |
#6
|
|||
|
|||
... I would like the Worksheet Tab Title to be in Cell A1 too.
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" wrote in message ... 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" wrote in message ... Is there a function that links the text on the Worksheet Tab to a Cell? Darrell -- Dave Peterson |
#7
|
|||
|
|||
... I would like the Worksheet Tab Title to be in Cell A1 too.
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" wrote in message ... 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" wrote in message ... Is there a function that links the text on the Worksheet Tab to a Cell? Darrell -- Dave Peterson |
#8
|
|||
|
|||
... I would like the Worksheet Tab Title to be in Cell A1 too.
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" wrote in message ... 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" wrote in message ... Is there a function that links the text on the Worksheet Tab to a Cell? Darrell -- Dave Peterson -- Dave Peterson |
#9
|
|||
|
|||
... I would like the Worksheet Tab Title to be in Cell A1 too.
?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 |
#10
|
|||
|
|||
... I would like the Worksheet Tab Title to be in Cell A1 too.
But I get a #value! error if the workbook wasn't saved.
David wrote: ?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 |
#11
|
|||
|
|||
... I would like the Worksheet Tab Title to be in Cell A1 too.
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 |
#12
|
|||
|
|||
... I would like the Worksheet Tab Title to be in Cell A1 too.
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Why can't I link a cell from worksheet to another when it has an . | Excel Worksheet Functions | |||
Refrencing another cell in a worksheet that "could" exist | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
name of another worksheet in cell for reference | Excel Worksheet Functions |