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.
Bookmarks