Great. Your second option is working as in deed, the DH are not in a consecutive order.

Lastly, and then it should work fine. How do I break the loop after the last cell of the range, to then go on with the rest of the code.

At the moment, I get a bug after the loop has gone through the whole range.

The number of loop performed must be related to the size of the range (e.g. A19:A26 is 5 loops, A19:A23 is 4 loops and so forth....)

To sum up:
If the loop has gone through the whole range
Then, break the loop and go on with the code

Cheers