|
本帖最后由 laoau138 于 2017-3-24 17:23 编辑
VBA先固定A列 再用5个数字组合输出B列
- Sub aaa()
- Dim i&, j&, k&, l&, m&, s$, r&, arr(1 To 719, 1 To 2), n&
- Set d = CreateObject("scripting.dictionary")
- For i = 1 To 5
- For j = 1 To 5
- If j <> i Then
- For k = 1 To 5
- If k <> i And k <> j Then
- For l = 1 To 5
- If l <> i And l <> j And l <> k Then
- For m = 1 To 5
- If m <> i And m <> j And m <> k And m <> l Then
- s = i + 4 & j + 4 & k + 4 & l + 4 & m + 4
- For n = 1 To 5
- r = r + 1
- arr(r, 1) = n - 1
- arr(r, 2) = Mid(s, n, 1)
- Next n
- r = r + 1
- s = ""
- End If
- Next m
- End If
- Next l
- End If
- Next k
- End If
- Next j
- Next i
- [a1].Resize(UBound(arr), 2) = arr
- End Sub
复制代码
|
|