Sheet Tab name

[SS]

Hi

Does anyone know if there is a way to pick up the sheet name in a cell?

Thanks
Shona

 

[Jack Schitt]

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

Workbook needs to be saved before the above will work.
You may wish to substitute the cellreference of the calling formula instead
of A1, if there is a risk of Row 1 or Column A being deleted at some later
date.

 

[Andy Brown]

Does anyone know if there is a way to pick up the sheet name in a cell?

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

File must be saved before this will work.

Rgds,
Andy

 

[SS]

Thanks that is great

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