Excel VBA - Copy Sheet and rename
Posted on 2013-01-20
I have my code to copy the current sheet and rename it. It is module. But for some reason it will not let me rename it. I keeps erroring out saying I can not duplicate a sheet name.
I assume when I add a sheet, or copy a sheet the "new" sheet is the active sheet. Here is my code:
Public Sub ADDMONTH()
Range("L3").Value = ActiveSheet.Previous.Range("L3").Value + 1
ActiveSheet.Name = Format(ActiveSheet.Range("L3"), "mmmm")
What could I being doing wrong or what have I missed?
Any help would be appreciated -