Monday, 20 May 2013

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"


 

No comments:

Post a Comment

Popular Posts

Search This Blog