Cell Value Equals sheet Name

Good morning Vetequk

Originally Posted by Vetequk

Is there a formular I can place in a cell to make the value of the cell the same as the sheet name, so if I change the sheet name it will automaticlly change the value in that cell.

Surprisingly (or maybe not!!), there isn't a straightforward formula to give you this, but it can be done using the CELL command, the only caveat being that the workbook must be saved - it won't work on a new workbook until it's given a filename :

=MID(CELL("filename",A1), FIND("]", CELL("filename", A1))+ 1, 255)

HTH

DominicB