What I am trying to do is on spreadsheet open is;

Checks cell E2 (contains a date)
- If E2 < second date (specified on different sheet within same workbook) perform action
- Move to next row, same column
...and this will loop until E2 >= the second date

I think I am getting close (don't laugh if I am way off) but just can't get it working correctly.
The code I have is....

Private Sub Workbook_Open()
    Dim TestDate As String
    TestDate = ""
    Dim i As Integer
    i = 2
    Dim wks As Worksheet
        With Worksheets("Block")
                Do Until TestDate = "End"
                    If Range(Cells(i, 5)) < Worksheets("Validation").Range("$A$21") Then
                        Range("A" & ActiveCell.Row).Resize(, 13).Interior.ColorIndex = xlColorIndexNone
                        i = i + 1
                    Else
                        TestDate = "End"
                    End If
                Loop

Thank you.