|
发表于 2014-3-14 17:26
|
显示全部楼层
本楼为最佳答案
- Sub Macro1()
- Dim arr, brr, d, i&, x&, y&, n&
- Set d = CreateObject("scripting.dictionary")
- arr = Range("a1").CurrentRegion
- ReDim brr(1 To 50, 1 To 2)
- x = UBound(arr)
- For i = 1 To UBound(brr)
- line1:
- y = Int(Rnd * x + 2)
- If Not d.exists(y) Then d(y) = "" Else GoTo line1
- Next
- For i = 1 To d.Count
- n = Application.Small(d.keys, i)
- brr(i, 1) = arr(n, 1)
- brr(i, 2) = arr(n, 2)
- Next
- Range("c2").Resize(UBound(brr), 2) = brr
- End Sub
复制代码 |
|