VBA - Find/Locate Cell Macro

[clprdctn]

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.

[JieJenn]

Change your LookIn from xlValues to xlFormulas

Please Login or Register  to view this content.

[clprdctn]

....And it works perfectly! Thank you JieJenn!