Sheet Name in Cell
 

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

Sheet Name in Cell
 

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

Sheet Name in Cell
 

Jay, have a look here,

http://www.xldynamic.com/source/xld.xlFAQ0002.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"Jay" wrote in message
...
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