Capturing Application.Match error using loops

[IRN_HU]

I want to locate the position of two dates inside a list of sequential dates.

The list is arranged earliest date to latest date.

The first date is the start_date, if the start_date is not contained in the list, it should increase by one until a match occurs.

The second date is the end_date, if the end_date is not contained in the list, it should decrease by one until a match occurs.

I currently use Application.Match to look for each date, and unsuccessfully try to fit a loop to capture any error, and increase (decrease) the start (end) date.

[AB33]

Why can not use For loop instaed of Do loops?

One way to remove the error if there is no match.

Please Login or Register  to view this content.

[1aaaaaaaaaaaaaaa]

Hiya, I think something like this should work for you.

Please Login or Register  to view this content.

[IRN_HU]

AB33 I'm not exactly sure how to implement your suggestion.

Poizhan your code is too advanced for my level.

[Norie]

IRN_HU

What result would you expect from the data in the workbook you uploaded?

[1aaaaaaaaaaaaaaa]

Apologies for the complexity, I would be happy to chat and explain the logic / methodology