Hey all,

Relatively new to VBA and trying to figure out a way around this issue but I just cant seem to get it to work without crashing my excel.

I'm trying to check a table within a worksheet for any repeat values in columns c & d indepentently and make sure that the each row with found repeat values is separated by at least 7 rows.

To give you background this is for participants at a horse show, each horse or participant needs 7 participants to warm up. So when creating the list there needs to be sufficient time.

Obviously if the list is not large enough, I just have it skip. But it just keeps failing.

Do I provide the code here for reference or how does this work?

TIA!