Searching for a date using VBA in Excel

[bdw146]

I am trying to use VBA to search for dates that already exist in an Excel worksheet. I think I may need some kind of date qualifier (similar to the Val qualifier).

This is what I have written right now:

For Each cell In Range("AllDueDate&quot
If cell = SearchForm.DueDate Then
Counter = Counter + 1
lRow = Worksheets("Search Results&quot.Range("a65356&quot.End(xlUp).Row
cell.EntireRow.Copy Worksheets("Search Results&quot.Range("A" & lRow + 1)
End If
Next cell

If anyone can help it would be greatly appreciated.

Thanks,

Brian

 

[bdw146]

I just saw my answer under another posting. No need to reply. Thanks anyway!!