Hi,
I have this macro that works fine; it copies the date from a cell in that sheet to the tab name.
Sub myTabName() ActiveSheet.Name = ActiveSheet.Range("A1") End Sub
How can I modify it so it can change the other 11 tabs so I have a full year of monthly tabs in sequence?
Thanks