To answer my own question it appears that the VBA method "find" does not work with dates. The reason is that Excel dates are represented as numbers (seconds since whenever) but not so in VBA. There are workarounds which I was given by the MS Community to be found at https://stackoverflow.com/questions/45639660/ex...


but they are messy and in my case a for_next loop is an adequate solution.