Hello I am trying to use this formula to get the worksheet names in cell A1:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)
It works for all sheets except for the Categories sheet. There is a named range in column A which I think is conflicting with the formula.
Can someone please check this?
Thank you very much
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)
It works for all sheets except for the Categories sheet. There is a named range in column A which I think is conflicting with the formula.
Can someone please check this?
Thank you very much