Skip loop if cells equal same values

Still getting the same compile error without dots in ".range"

ok, we have progress in that line of code now works but the code overall doesn't do what I was looking for.

I have attached a workbook to try and show you more clearly. If you click CommandButton2 then it will run the code we are discussing. Now, in this example, the code we changed should mean that only the first match (Arseanl v Bolton) on the 'coupon' is process because all the other matches have the same values in columns J & K as BB & BC. However, all matches are processed and copied on to the csv files created. The csv files on this example should only contain the Arsenal v Bolton match.