|
- Private Sub CommandButton1_Click()
- Dim brr(1 To 4, 1 To 3)
- Dim rng As Integer
- With Sheets("参数")
- arr = .Range(.[a3], .[a3].End(xlToRight)) '所有数字
- ReDim crr(1 To UBound(arr, 2)) '去掉空单元格
- For i = 1 To UBound(arr, 2)
- If Len(arr(1, i)) > 0 Then '去掉空单元格
- n = n + 1
- crr(n) = arr(1, i)
- End If
- Next
-
- For k = 1 To 4
- drr = crr
- p = n
- q = IIf(k <= 2, 2, 3)
- For i = 1 To q
- rng = Int((p * Rnd) + 1)
- brr(k, i) = drr(rng)
- drr(rng) = drr(p)
- p = p - 1
- Next
- Next
- .Range("b17").Resize(4, 3) = brr
- End With
- End Sub
复制代码 |
|