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:

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.
--
Jay