Sub RadomChoose()
Dim T%, T2%, CelVl, cell As Range, K%, ARR
ReDim ARR(1 To 10)
retry:
With Sheets("Sheet1")
T = .Range("A65536").End(xlUp).Row
T2 = Int((Rnd * T) + 1)
CelVl = .Cells(T2, "A")
End With
For Each cell In Sheets("Sheet2").Range("A1:A10")
If cell.Value = CelVl Then GoTo retry
If cell.Value = "" Then
K = K + 1
ARR(K) = cell.Row
End If
Next
If K = 0 Then
MsgBox "10 choosed"
Exit Sub
End If
Sheets("Sheet2").Cells((ARR(1)), "A") = CelVl
End Sub
温馨提示:答案为网友推荐,仅供参考