Worksheet name, dynamically using formula
April 3, 2018
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)
About The Author
ANmar
An Excel-Passionate user, developer and teacher Love finding new ways to solve daily issues and enhances to regular users, then teach that