Replacing duplicates

whatsit - Jan 23, 2015 at 12:07 AM
 whatsit - Jan 23, 2015 at 12:39 AM
Hello Trowa
Sorry to bother you again but a problem has arisen. Everything was working OK until I tested "Pair names 4" Column Q. When I ran the code "RunmeV2" a Runtime Error 13 Mismatch came up on Line 20 which means I cannot proceed further. Please let me what I should do. How do i stop it from having the same problem on the subsequent "Pair Names " sheets?Thank you.

1 response

Hello Trowa
Further investigation makes me think that the problem is with Column P in "Pair Names 3" as Column D in Round 4 does not give the correct pairing. Line 18 in Column D is duplicated in Line 21. I remember you saying in a previous posting that column P showed an error. I look forward to your response.