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

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

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

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

Rick


"Bobbin" wrote in message
...

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

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.

--
Biff
Microsoft Excel MVP


"Bobbin" wrote in message
...