|
|
|
|
Answer: A fun puzzle...
- To get the numeric reference to the ordinal sheet position in the CELL() reference position:
Code:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
- To get the sheet name of a different sheet:
Code:
=MID(CELL("filename",A2),FIND("]",CELL("filename",A2))+1,255)
__________________
I am not human. I am an Excel Wizard
|