Sheetname

  • Thread starter Thread starter maxximuss
  • Start date Start date
M

maxximuss

Hi,

could any one help me with the following:

I want to change a sheetname with a formula. Is it possible and if yes
how?

Thanks a lot
 
Not with a formula - you'll need to use VBA. This should do it:

Sub a
Sheets("sheet1").Name="AnotherSheetname"
end sub

--

Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
 
Thank you,

but could you please tell me how can I input the name of the new (o
other existing) sheet somewhere within the worksheet and the macro t
change the name of the other sheet. (may be I have to use longer VB
macro with input...?
 
Suggestion: Connect directly to microsoft's news server,
msnews,microsoft.com. It appears you're using a web site of some kind,
which makes a mess of the threading in newsgroups. If you have Outlook
express, it's Tools, Accounts, News, Add. Besides, why should the free work
we do in the newsgroups support sites with advertising and stuff?
 
I am sorry for this. I did not know that I am causing any troubles
Please excuse me. I am an individual and I just needed some help....:
 
Maxximuss,

Open the workbook, let's say you want to name the sheet after A1 on the
active sheet
Press Alt + F11, click insert>module and paste in the below

Sub Test()
ActiveSheet.Name = Range("A1")
End Sub

press Alt + Q to close the VBA editor.

Now put a name in A1, press enter
press Alt + F8 and select the macro name and either double click it or
select and click run.
Replace Test with what you want to call it

The reason you were given advice to connect from the MS server is that it
doesn't
screw up threading of the posts and many people object to that their help is
used
on a commercial website..
 
Back
Top