Home > VBAUsefulCodes
Renaming is simply done by setting new name of the worksheet to the .Name property of a worksheet as shown in below code
Excel Macro to rename a worksheet
Renaming is simply done by setting new name of the worksheet to the .Name property of a worksheet as shown in below code
Sub renameWorksheet()
Dim wb As Workbook
Dim sh As Worksheet
Dim newSheetName As String
newSheetName = "MYNEWSHEETNAME"
Dim fPath As String
fPath = "C:\myfile.xlsx"
Set wb = workbooks.Open(Filename:=fPath)
' Rename the sheet name of the 1st sheet
Set sh = wb.Worksheets(1)
sh.Name = newSheetName
End Sub
Subscribe
More to Explore
Tags
VBA Outlook KPI Excel Alt+F11 Dashboards Macros Recording Graphs Automation Developer WaterFall Powerpoint Charts Pivot Tables Forecast Charts