Range.Find() triggers on wrong date, what options do we have?

Question

Within a tool I'm opening the weekly hours and declarations and search for booked hours/holidays etc. For some reason the ....range.find() method finds that 22-2-2025 (Februari) from the weekly report is equal to 22-12-2025 (December) from the dates in range 'B:B' and returns the row 88. I added a breakpoint and monitored the cell values in the watchlist. What is going wrong? How can I solve this? Or do I have found a bug within excel?

Answer 1

Try to add a parameter: Find(... , lookat:=XlLookAt.xlWhole).