MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Sheet names in cell


Posted by Peter Puniter on February 06, 2002 8:26 PM

Hallo, Is there a formula for a cell which can put the sheet name into that cell. You could do it in Lotus I think with something like
=cellinfo("sheetname",(a1))

Thanks
Peter


Posted by anno on February 06, 2002 8:35 PM

use =RIGHT(CELL("filename",A2),LEN(CELL("filename",A2))-FIND("]",CELL("filename",A2),1)) but save file after pasting into each sheet. thanks to mark w for this one.

Posted by Peter Puniter on February 07, 2002 3:40 PM

Cheers - working well