Search:

MS Office Answers

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question Asked By: Conrad Evans on Sep 07 In MS Office Category.

Change the Current Sheet Name

Question Answered By: Zane Thompson on Sep 07

Sub WorkSheetNameChange()

Worksheets("Sheet2").Name = "New Name"
End Sub

Or you may refer to the sheet by its internal number. But perhaps you
should first read up more about the object model in the VBE Help file.
Start by searching for worksheet.

This Question has 2 more answer(s). View Complete Question Thread

Didn't find what you were looking for? Find more on Change the Current Sheet Name Or get search suggestion and latest updates.

Related Topics:

Retrieve data from Sheet with SQL and put it in Another sheet
unprotect the sheet, insert hyperlink & then protect the sheet
UDF Works only in One Sheet, Not in Other Sheets
List in one sheet unanswered questions in checklist sheet
other sheet's active cell
MERGE TWO SHEET IN ONE NEW SHEET
name was started with an invalid character Cannot view XML input using XSL style sheet
Excel 2000 Picking up sheet name
naming sheet object and calling it by that
How to Copy the name of a sheet
identifying sheet name from the cell
Changing Chart attributes without activating the sheet/chart
possible to change Protected Sheet error message?
putting current date into file name when saving
how do I get the current worksheet name into a variabl
macro to get info from workbook thats name changes
Changing Caption of form by name at runtime
Change Workbook's Name
Lookup on a sheet so that every time when file open it copes data from another file sheet
linking cascading style sheet

Tagged:change the current sheet name

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us