[mso] Re: Rename a Spreadsheet tab

Hi John,

This is what I have in my stuff.  Don't know the difference, but it works
for me.  Just tried it again.  Using Excel 2002.

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,LEN(CELL("filename"
,A1))-FIND("]",CELL("filename",A1)))

Jim
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of John Clarke
Sent: Thursday, November 06, 2008 9:49 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Rename a Spreadsheet tab


Hello Lisa
Thank you for the reply. I typed the formula (exactly) into cell A1, but it
doesn't work for me. I am using 2003.

I renamed the tab to be BAR then typed in the formula, I also did it the
other way round, formula first then rename tab. Am I missing something?

Thanks
> =TRIM(MID(CELL("filename",A1),(FIND("]",CELL("filename",A1))+1),50))
> The CELL("filename",A1) function returns a *very* complete reference 
> to that cell.
> The FIND then finds the first occurence of ].
> The MID function then takes the string and picks out the text +1 character
> after the find to the end.
>
> HTH
> Lisa
>
> > Is there a way in which I can automattically rename a tab to show 
> > what is entered in cell A1? For example; If I run a hotel business 
> > that has different workbooks for the Bar, Restaurant and Rooms etc. 
> > The first sheet will be an amalgamation of all the workbooks,  on 
> > the second worksheet I type "BAR" into cell A1. I then want this
> > to rename the tab from sheet2 to BAR.
> >
> > All help will be greatly appreciated.
> >
> > John
>
> *************************************************************
> You are receiving this mail because you subscribed to 
> mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx
>
> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
> To Unsubscribe from this group, visit the group's homepage and use the 
> dropdown menu at the top.  This will allow you to unsubscribe your 
> email address or change your email settings to digest or vacation (no 
> mail). http://www.freelists.org/webpage/mso
>
> To be able to share files with the group, you must join our Yahoo 
> sister group.  This group will not allow for posting of emails, but 
> will allow you to join and share problem files, templates, etc.: 
> http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for 
> FILE SHARING ONLY.
>
> If you are using Outlook and you see a lot of unnecessary code in your 
> email messages, read these instructions that explain why and how to 
> fix it: http://personal-computer-tutor.com/abc3/v28/greg28.htm
> *************************************************************
>


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the
dropdown menu at the top.  This will allow you to unsubscribe your email
address or change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister
group.  This group will not allow for posting of emails, but will allow you
to join and share problem files, templates, etc.:
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister group. 
 This group will not allow for posting of emails, but will allow you to join 
and share problem files, templates, etc.:  
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE 
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: