Link name of the sheet to a cell.

[Gareth]

Hi all, I am trying to link the name of the sheet (in the tab at the
bottom of the workbook) so it appears in a cell.

Cheers

 

[BrianB]

=MID(CELL("filename"),FIND("]",CELL("filename"),1)+1,256

 

[Andy B]

Hi

Try one of the following formulas (note: the workbook has to be saved before
it'll work)

File path and file name:
=CELL("filename",A1)

File path only
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-1)

File name only
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CELL("fi
lename",A1),1)-FIND("[",CELL("filename",A1),1)-1)

The sheet name
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename"
,A1),1))

Copy and paste the above formulas as they are - as a single line.