cell needs to show tab text
Hi,
Try this
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
The workbook must be saved for it to work.
Mike
"klee" wrote:
I have a multi-tabbed workbook. I would like to link a cell to the text
entered on the worksheet tab... I've seen it done before - but don't know how
they were able to do that... Can someone fill me in?
Thanks!
|