We can change the Sheet Name by using Name Property of the Sheet Object. There are many ways to rename the sheets.
VBA to Change a Sheet Name
We can use Name Property of the Sheet Object to change the name of the Worksheet. We refer the existing sheet by its Sheet Name or Sheet Number and set the value of its Name Property.
Sheets (<Name/Number>).Name="New Name"
Rename a Sheet using Sheet Number
We can rename a sheet by its number. Sheet number is the order number from left in the Workbook Sheet Tabs. For example, if you want to change the name of the 3 sheet in the workbook. You can refer it as Sheets(3) and use Name Property to Change it.
Sheets(3).Name="New Name"
Rename a Sheet using Sheet Name
Existing Sheet Name can be changed using its name. Sheet name can be seen in the Workbook Sheet Tabs. For example, if you want to change the name of the “CurrentSheetName” in the workbook. You can refer it as Sheets(“CurrentSheetName”) and use Name Property to Change it.
Sheets("CurrentSheetName").Name="New Name"
Change the Name of the Active Sheet
Active Sheet Name can be changed by referring ActiveSheet object. For example, if you want to change the name of the Active Sheet to “New Name”, you can set the Name Property of the ActiveSheet object to “New Name”.
ActiveSheet.Name="New Name"
