Sub ChangeSheetName(SheetOldName As String, SheetNewName As String)
Sheets(SheetOldName).Name = SheetNewName
i was using this vba code to change the sheet name any suggestion other than this code please.
in my project this formula is not applicable for few states excel sheets .
need another way do to this.
my sheet name will be changing always and it is not dynamic