本帖最后由 爱疯 于 2016-9-14 12:31 编辑
'N
Sub test()
[a1].CurrentRegion = ""
Call dg("", 2, 0, 0, 0, 0, 0)
End Sub
'
'1s
'2n
'3k
'4a
'5b
'6c
'7
Sub dg(s, n, k, a, b, c, t)
If a = n Or b = n Or c = n Then
k = k + 1: Cells(k, 1) = s: Cells(k, 2) = t
Else
For i = 1 To 3
Select Case i
Case 1
Call dg(s & "a", n, k, a + 1, b, c, t + 1) 'a
Case 2
Call dg(s & "b", n, k, a, b + 1, c, t + 1) 'b
Case 3
Call dg(s & "c", n, k, a, b, c + 1, t + 1) 'c
End Select
Next
End If
End Sub
лл
10#32
1kn
棬Щ
棬
е
2бκ鷵Ρ
iffalsetrueΣ |