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