How to rename the Excel Worksheet Using VBA Macro

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"