I have 60 tabs - one for each month beginning Oct 2009 for 5 years. Is there a VBA code so I can name the tabs as: Oct 09, Sep 09… so on? Appreciate any help. It will save me some time naming the tabs manually.
This is what interns are for.
OK, I actually figured out. For those who are interested, might find this useful: Sub createtabs() Dim myDate As Date Dim mySheet As Worksheet myDate = #10/31/2009# While myDate >= #9/30/2003# Set mySheet = ActiveWorkbook.Worksheets.Add mySheet.Name = Format(myDate, “MMM YY”) myDate = eomonth(myDate, -1) Wend End Sub