|
~~~~~~
- Sub test()
- Dim arr As Variant
- Dim brr(1 To 720, 1 To 6)
- Dim dic As Object
- Set dic = CreateObject("Scripting.Dictionary")
- Dim st As String
- Dim s As String
- Do
- st = "ABCDEF"
- For j = 6 To 1 Step -1
- i = Int(VBA.Rnd() * j + 1)
- s = s & VBA.Mid(st, i, 1)
- st = Application.WorksheetFunction.Substitute(st, Mid(st, i, 1), "")
- Next j
- dic(s) = ""
- s = ""
- Loop Until dic.Count = 720
- arr = dic.keys
- For m = 1 To 720
- For n = 1 To 6
- brr(m, n) = VBA.Mid(arr(m - 1), n, 1)
- Next n
- Next m
- Range("a1").Resize(720, 6) = brr
- End Sub
复制代码
|
评分
-
1
查看全部评分
-
|