Formula to Return Excel Sheet Name

[KVASEY]

=""&MID(CELL("filename",Sheet1!$A$1),FIND("]",CELL("filename",Sheet1!$A$1))+1,256)


1. Change filename to the your workbook's filename.
2. Change Sheet1 to your current sheetname where you have pasted the formula.



This formula below which I found on many forums doesn't really work because if you have it on 10 sheets and recalc, all 10 sheets will have the sheetname that is active.
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)

 

[Jonmo1]

You need to add a cell reference (without the sheetname) to make it specific to each sheet

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

 

[dotxl]

This thread has long been dormant but I created a Name (ThisWS) in the Name Manager with the following formula in the "Refers to:" section: =MID(CELL("filename",INDIRECT("A1")),FIND("]",CELL("filename",INDIRECT("A1")))+1,255). Referring to ThisWS (as =ThisWS) in any sheet returns the sheet name of the sheet (not just the last sheet calculated). Hope this helps.