View Single Post
  #4   Report Post  
Peo Sjoblom
 
Posts: n/a
Default ... 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