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