I am trying to right an IF in VBA that says:

E.g. If cells in the range("a2:d10") = worksheets("sheet1").Cells("a2")

In cell a2 the date is in a date format, where as in the range there is just the day number and the month and year are in the title bar c3 in a format of say JANUARY2010.

How would I write this in VBA?