- Sub 三码组合()
- Dim d As Object, ar, br, cr, arr, brr(), s$, i, j, k, m, n
- Set d = CreateObject("scripting.dictionary")
- ar = [b4:m4]: br = [b5:m5]: cr = [b6:m6]
- ReDim arr(1 To 2744, 1 To 3)
- For i = 1 To 12
- For j = 1 To 12
- For k = 1 To 12
- s = ar(1, i) & br(1, j) & cr(1, k)
- If Not d.exists(s) Then
- m = m + 1
- d(s) = m
- arr(m, 1) = ar(1, i): arr(m, 2) = br(1, j): arr(m, 3) = cr(1, k)
- End If
- Next
- Next
- Next
- ReDim brr(1 To m, 1 To 3)
- For i = 1 To UBound(arr)
- If Len(arr(i, 1)) > 0 And Len(arr(i, 2)) > 0 And Len(arr(i, 3)) > 0 And _
- arr(i, 1) <> arr(i, 2) And arr(i, 2) <> arr(i, 3) And arr(i, 1) <> arr(i, 3) Then
- n = n + 1
- brr(n, 1) = arr(i, 1): brr(n, 2) = arr(i, 2): brr(n, 3) = arr(i, 3)
- End If
- Next
- [o4:q2745].ClearContents
- [o4].Resize(n, 3) = brr
- Set d = Nothing
- End Sub
复制代码 Set d = CreateObject("scripting.dictionary") 这句没有,你的字典根本就没有创建出来 |