Hjemmet
Your code seems to work as intended here, with no error.
I can't reproduce the error.
Could you tell us how to get the error, which player to choose, whether a specific Cup should be chosen. Attach another workbook if necessary.

Penny drops (I can't open your recording.zip).
You're seeing a zero for the min value when there at least one blank in Dart's columns of that player.
That's because there are zeroes in sq, and that's because you've used Val()
Try removing the Val bits: 
           c00 = c00 + .Column(j + 0)
           sp(j \ 3) = .Column(j + 1)
           sq(j \ 3) = .Column(j + 2)
(And keep the redim sp(6) without the As Double otherwise the zeroes will return)
SamT , note that the original code uses a backslash, not a forward slash for the division, I think it's call integer division, and it returns a valid index (a whole number) for the sp and sq arrays.