Hi Norbert,

Am Thu, 6 May 2021 22:11:35 -0700 (PDT) schrieb Norbert:

Set c = .Range("H7:H18").Find(myDate, after:=Range("H18"))

What roll does [after:=Range("H18")] play?
Why H18?

in OneDrive are macros disabled.
You must download the file to test it.

Without the line above Excel searches after H7 and a match in H7 will
not be found.


Regards
Claus B.
--
Windows10
Microsoft 365 for business