How to get and print the active sheet name inside a cell?
There is no direct way to access the sheet name, but you can get the file name and parse the file name field to get the active sheet.
=RIGHT(CELL("filename"),LEN(CELL("filename"))- FIND("]",CELL("filename"),1))
There is no direct way to access the sheet name, but you can get the file name and parse the file name field to get the active sheet.
=RIGHT(CELL("filename"),LEN(CELL("filename"))- FIND("]",CELL("filename"),1))
No comments:
Post a Comment