Dates can also be in more columns. Lets say AV2:IV1056

The code should work irrespective of the rows and columns.

Maxi

"mac_see" wrote:

It works but it will stop at BB10. if I have dates in more rows lets say
AV2:BB750, the code would be very long. I don't know VBA but can you use
something like xlDown so that irrespective of the date range, it will still
give you result and the code will be short?