Get the name of the active worksheet in active workbook, using formulas only

This function needs to have workbook saved

Then, you just paste below formula into any cell …

Other than A1 🙂

 
=MID(CELL("filename",$A$1),SEARCH("]",CELL("filename",$A$1))+1,500)

 

 

Comments

comments