Is there a way to say that MyArray(5) cannot equal any element of the
array, without listing each element, as below?
Do
MyArray(5) = Int(10 * Rnd)
Loop Until MyArray(5) < MyArray(4) And _
MyArray(5) < MyArray(3) And _
MyArray(5) < MyArray(2) And _
MyArray(5) < MyArray(1)