How do I output the worksheet name in cell?
 

I want to make a cell that outputs the name of the worksheet.

Hi Sloth,

Try this:

=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1) )-FIND("]",CELL("filename",A1)))

Note: this formula will work if your workbook has been saved at least once.

Regards,
KL


"Sloth" wrote in message
...
I want to make a cell that outputs the name of the worksheet.

One way:

http://www.mcgimpsey.com/excel/formu..._function.html


In article ,
"Sloth" wrote:

I want to make a cell that outputs the name of the worksheet.

Thanks guys, that's what I needed.