MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Change the Current Sheet Name

  Asked By: Conrad    Date: Sep 07    Category: MS Office    Views: 835

How can we change the name of current worksheet through VBA.



3 Answers Found

Answer #1    Answered By: Ayaz Hashmi     Answered On: Sep 07

ActiveWorkbook.ActiveSheet.Name = "newname"

Answer #2    Answered By: Zane Thompson     Answered 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.

Answer #3    Answered By: Constance Reid     Answered On: Sep 07

Or you can use

Worksheets(x).Name = "new name"

where x is the position of the worksheet.

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