Sheet Name in Cell

[Guest]

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.

 

[Guest]

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:

 

[Paul B]

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