Cell Value vs TabSheet Name
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
Note: The workbook have to save first
"Ken" wrote:
Excel2003 ... Is it possible to have a cell value linked to a TabSheet Name?
My TabSheets are peoples names ... & in a cell within the TabSheet I have
the same name ... If I change TabSheet name ... I would like the name within
the TabSheet cell to change as well ... Can I do this?
Thanks ... Kha
|