how can i get a cell to display the sheet name it's on?

[Rick Rothstein \(MVP - VB\)]

As long as the workbook has already been saved, you can use this formula...

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

Rick

 

[T. Valko]

Try this:

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

Note: do not change "filename". Enter the formula exactly as shown.

The file must have been saved at least once for this to work. In other
words, the file must already exist. A file doesn't exist until it is saved
and given a name.