Dr. K you solved my problem. Thanks a bunch for explaining that out to me. Yes, I had not used the LookIn:= part in the find. The reason, I guess, it worked afterward is because I've got another macro that has to search for a value in another worksheet and display data from that worksheet. Also, my first .Find in this macro is to search for a text value while the other is a date value which is stored as m/d/yyyy but displayed as dd-mmm. Gotta use the full .Find function now onwards. Thanks again.

Lincoln