Forum Discussion
Formula for Cell Value as Worksheet name
Hi there,
I have been using the below formula to make cell A1 in my worksheet display as the worksheet name tab (lets call it sheet 1). This works fine apart from when I go to a alternate work...
Hi Nigel,
You have to specify a reference to the CELL function on the current worksheet!
So replace that formula with this:
=MID(CELL("filename",A1),FIND("]",CELL("filename"))+1,1255)
Or this:
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-SEARCH("]",CELL("filename",A1)))