- Sub GetCombin_dg()
- Dim tms#
- tms = Timer
- m = [a1].End(2).Column: sj = [a1].Resize(, m)
- n = 8: w = " "
- [a3].CurrentRegion = ""
- ReDim jg(Application.Combin(23, 8), 7)
- k = 0: Call dgQZH("", 0, 0)
- [a3].Resize(k, 8) = jg
- MsgBox "组合数:" & k & vbCrLf & "用时:" & Format(Timer - tms, "0.000s")
- End Sub
- Sub dgQZH(r$, i&, t&)
- Dim j&, x%, ar
- If t = n Then
- ar = Split(r)
- For x = 1 To 8
- jg(k, x - 1) = ar(x)
- Next
- k = k + 1: Exit Sub
- End If
- For j = i + 1 To m
- Call dgQZH(r & w & sj(1, j), j, t + 1)
- Next
- End Sub
复制代码
Book8码.rar
(19.56 KB, 下载次数: 47)
|