Worksheet Tabs


Posted by Tim Johnson on February 08, 2002 8:57 AM

Is there a way to link a formula to a worksheet tab? I have several places in a spreadsheet that I would like to equal the name on the worksheet tab...

Posted by Tom Urtis on February 08, 2002 9:17 AM

Try this:

=RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename")))

T.U.



Posted by Tom Urtis on February 08, 2002 9:21 AM

Caveat on my response...see 20787.html for better idea. (nt)