Finding Dates VBA

[friz8070]

Hi guys,

Sorry if this was addressed elsewhere but I'm trying to search for a date in cell I2 in the rest of the sheet. However, I keep getting nothing.

Please Login or Register  to view this content.

So it returns "Nothing found" rather than highlighting the cell that matches the date in cell I2.

Any help would be appreciated.
Thanks.

[TMS]

Difficult to tell why it's not finding anything without knowing what's in I2 and what's in the range you're searching.

It'd be an idea to post a sample workbook to go with the code.

Regards

[friz8070]

Difficult to tell why it's not finding anything without knowing what's in I2 and what's in the range you're searching.

It'd be an idea to post a sample workbook to go with the code.

Regards

Sorry, here is the workbook.

Book1 - Copy.xls