Share via

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

Ludo Houben 0 Reputation points
2025-04-18T13:17:12.3+00:00

afbeelding

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?

VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,827 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Viorel 121.3K Reputation points
    2025-04-18T15:20:05.64+00:00

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

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.