Sheet Name in Cell

J

Jay

It's useful to show the sheet name or workbook title in a cell within the
workbook. What formula works best for this. It's important that the sheet
name not change when I'm active on another sheet (i.e., active on the first
sheet, but printing several grouped sheets). Thanks.
 
M

Marcelo

hi Jay


=right(cell("filename",a2),len(cell("filename",a2))-find("]",cell("filename",a2)))

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Jay" escreveu:
 
Top