How do I output the worksheet name in cell?

[Sloth]

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

 

[KL]

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

 

[JE McGimpsey]

One way:

http://www.mcgimpsey.com/excel/formulae/cell_function.html

 

[Sloth]

Thanks guys, that's what I needed.