VBA - Find/Locate Cell Macro

Book2.xlsm

I have the code below, basically it's supposed to find whatever I put in cell B1, in the active spreadsheet. As you can see in the attachment -- it works well with words but I try to use it with Dates, it doesn't work.

Your help on this would be greatly appreciated!

Thanks!

Please Login or Register  to view this content.

Change your LookIn from xlValues to xlFormulas

Please Login or Register  to view this content.