Good morning fellas!
How can I change the code below
Sub ChngSheetName()
ActiveSheet.Name = "Template1"
End Sub
So that if "Template1" already exist in the workbook it will rename to "Template2" and if that exist to "Template3" and so on.
Thanks
How can I change the code below
Sub ChngSheetName()
ActiveSheet.Name = "Template1"
End Sub
So that if "Template1" already exist in the workbook it will rename to "Template2" and if that exist to "Template3" and so on.
Thanks