Dear Forum Members:

Newbie here starting to feel the joys and pains of Excel VBA.

I have several dates in a column (EndDate). I want to find which cells are within a date range (FromDate to ToDate).
I have the following code

For i = 1 To 100
LicFF.Range("I" & i).Font.Strikethrough = False
EndDate = Format(LicFF.Range("I" & i), "mm/dd/yyyy")
If EndDate <> "" Then
If EndDate >= FromDate And EndDate <= ToDate Then
LicFF.Range("I" & i).Font.Strikethrough = True
Application.ScreenUpdating = False
Worksheets("FujiFilm").Range("B4:O5").Copy Worksheets("Lic-Rep").Range("B2:O3")
Worksheets("Lic-Rep").Range("A" & RepPointer).Value = "FujiFilm"
Worksheets("Lic-Rep").Range("B" & RepPointer & ":" & "O" & RepPointer).Value = LicFF.Range("A" & i & ":" & "N" & i).Value
Application.ScreenUpdating = True
RepPointer = RepPointer + 1
End If
End If
Next i

The problem I have is that the code is selecting cells within the specified range, but it is not considering the year. For example if i set from 1/1/2013 to 2/28/2013, the code will select all cells which are within 1/1 and 2/28 from any year.

Please let me know any suggestions.

Regards

RMCZ