I have 3 worksheet ( Sheet1, Sheet2, Sheet3 )
I have this formula to populate the worksheet's name into a cell.
= cell("filename")
it works, but if I switch worksheets, the previous value stays the same.it seems the =cell("filename") is not updating when I switch to the sheet.
or am I missing something?
Is there an easier way to define a worksheet's name ( either formula or custom function? )
I have this formula to populate the worksheet's name into a cell.
= cell("filename")
it works, but if I switch worksheets, the previous value stays the same.it seems the =cell("filename") is not updating when I switch to the sheet.
or am I missing something?
Is there an easier way to define a worksheet's name ( either formula or custom function? )