Forum Discussion
J00LiiWoo
Jun 02, 2023Copper Contributor
Formula provided by MS to insert worksheet name in cell is suddenly causing circular reference
I have been using the formula: =MID(CELL("filename",A1),FIND("]",CELL("filename"))+1,255) for years to insert a worksheet name into a cell in Excel. However, for the first time today (02JUN2...
Geoff_FalconSMG5
May 14, 2024Copper Contributor
- SergeiBaklanMay 14, 2024Diamond Contributor
It shall work if only formula is not entered in referenced cell (A1). More variants https://techcommunity.microsoft.com/t5/excel/how-to-reference-the-current-sheet-name-in-an-function/m-p/3797131