Sub AddSheets()
Dim varStartDate As Date, _
varEndDate As Date, _
varCurDate As Date, _
shtWs As Worksheet, _
wbkBk As Workbook, _
intShtStart As Integer, _
intShtCount As Integer, _
intRed As Integer, _
[COLOR="red"]strFormula as String[/COLOR]
varStartDate = "01/01/2011"
varEndDate = "31/12/2011"
Set wbkBk = ThisWorkbook
On Error Resume Next
Set shtWs = wbkBk.Sheets(Format(varStartDate, "ddmmmyy"))
On Error GoTo 0
If Not shtWs Is Nothing Then
varCurDate = varStartDate + 1
intShtStart = shtWs.Index
Set shtWs = Nothing
Else
varCurDate = varStartDate
intShtStart = ActiveSheet.Index
End If
Do While varCurDate <= varEndDate
With wbkBk
.Sheets(intShtStart).Copy After:=Sheets(intShtStart)
intShtStart = intShtStart + 1
.Sheets(intShtStart).Activate
End With
If intRed = 255 Then
intRed = 0
Else
intRed = 255
End If
With ActiveSheet
.Name = Format(varCurDate, "ddmmmyy")
.Range("A1").Value = Format(varCurDate, "dddd, Mmmm dd, yyyy")
[COLOR="Red"] If varCurDate > varStartDate Then
strFormula = "='" & Format(varCurDate - 1, "ddmmmyy") & "'!K70+K69"
.Range("J70").Formula = strFormula
End If[/COLOR]
.Tab.Color = RGB(intRed, 255, 0)
End With
varCurDate = varCurDate + 1
Loop
End Sub