 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / February 2007Tab name in specific cell
Can I have the tab name show in a specific cell, whereas when the tab name is changed, the cell reults also change ? And if so, is it simply a formula? Thanks, Steve Try this: =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) Does that help? *********** Regards, Ron XL2002, WinXP > Can I have the tab name show in a specific cell, whereas when the tab name is > changed, the cell reults also change ? And if so, is it simply a formula? > > Thanks, > > Steve I'm getting a #Value! =MID(CELL("Master"),FIND(")",CELL("Master"))+1,255) > Try this: > [quoted text clipped - 13 lines] > > > > Steve Steve.... Re: =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) You can just copy the formula directly from the post and paste it into the formula bar. "filename" is not the name of your file. It's the Info_Type to be returned by the CELL function. (I should have been more clear.) Does that help? *********** Regards, Ron XL2002, WinXP > I'm getting a #Value! > [quoted text clipped - 17 lines] > > > > > > Steve If you put my posted formula in more than one sheet..... all formulas will return the same value on all sheets (unless you recalculate) To force them to show the correct sheet names, try this, instead =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)&T(NOW()) *********** Regards, Ron XL2002, WinXP > Steve.... > [quoted text clipped - 36 lines] > > > > > > > > Steve Ok, great. Thanks. I thought filename was the name of the file. Also, before I saw this recalc post, I found some help here at work, and this formula also works =MID(CELL("filename",A4),FIND("]",CELL("filename",A4))+1,LEN(CELL("filename",A4))-FIND("]",CELL("filename",A4))) Thanks again, Steve > If you put my posted formula in more than one sheet..... > all formulas will return the same value on all sheets (unless you recalculate) [quoted text clipped - 49 lines] > > > > > > > > > > Steve See http://xldynamic.com/source/xld.xlFAQ0002.html  Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > Try this: > [quoted text clipped - 14 lines] >> >> Steve |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.