MrExcel Publishing
Your One Stop for Excel Tips & Solutions

sheet name in a cell


Posted by brian on January 15, 2001 7:59 AM

Is there a formula to have a cell display the sheet name?


Posted by Mark W. on January 15, 2001 8:25 AM

After the workbook has been saved for the 1st time
you can use:

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

Posted by Brian on January 15, 2001 8:31 AM

Thanks

Excellent!
Thanks Mark W.