Below Example will rename the given worksheet using Macro.
Syntaxt / Code to Name a worksheet.
Set ws= ActiveWorkbook.Worksheets("Sagar")
ws.Name = "NewName"
In above example, We have rename the "Sagar" worksheet with "NewName"
Syntaxt / Code to Name a worksheet.
Set ws= ActiveWorkbook.Worksheets("Sagar")
ws.Name = "NewName"
In above example, We have rename the "Sagar" worksheet with "NewName"
No comments:
Post a Comment