View Full Version : Showing worksheet tab name in cell


JiTS
02-22-2006, 01:19 AM
Hi! :)

I would like to show the worksheet tab name in a cell of that specific worksheet?

Is this possible with a formula in a cell?!?

shades
02-22-2006, 06:25 AM
Try this:

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

You have to save the workbook first if it is a new workbook.
________
Buy Extreme Vaporizer (http://www.vaporshop.com/extreme-q-vaporizer.html)

Sergeant
02-22-2006, 12:20 PM
Try this:

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

You have to save the workbook first if it is a new workbook.
Nice one. That is amazing!