Sheet Name Formula

This formula will return the name of the current worksheet: =MID(CELL(“filename”,INDIRECT(“rc”,)),FIND(“]”,CELL(“filename”,INDIRECT(“rc”,)))+1,255) Make sure that you've saved your file with a name other than Book1, otherwise the formula won't work.