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