Private Sub CommandButton1_Click()
Dim x As Byte, t() As Variant, y As Byte
Randomize
If Range("G10").Value = "" Then Exit Sub
t = Range("ba52:ba72")
y = Choose(WorksheetFunction.Match(Range("g10"), t, 0), 53, 57, 61, 65, 69, 73, 77, 81, 85, 89, 93, 97, 101, 105, 109)
x = Int((125 - 103 + 1) * Rnd + 103)
Range("g15").Value = Cells(x, y)
Range("g16").Value = Cells(x, y + 1)
While Range("g15").Value = "" Or Range("g16").Value = ""
x = Int((125 - 103 + 1) * Rnd + 103)
Range("g15").Value = Cells(x, y)
Range("g16").Value = Cells(x, y + 1)
Wend
End Sub