Forum Discussion
Workaround for sheet name in formula with Excel Online
Hi there !
I used an Excel File that used the CELL function in order to extract the sheet's name. But the CELL function does not exist in Excel Online. Could you help me find a workaround to extract the sheet's name without the CELL function, that works in Excel Online ?
Kind regards
Flo
As Hans already replied, this is discussed in workbook and sheet name via formula.
At the end, you will find a new addition (by me [smile]) on how get the worksheet name without VBA and without hidden sheets, exploiting FORMULATEXT on the formula of the cell itself.
See the reply by Bloggs20 near the end of the following discussion:
