第1个回答 2012-11-19
打开一个EXCEL表,同时按:Alt+F11,进行宏编辑界面
双击SHEET1,把下列代码复制粘贴到代码编辑区
按F5运行,关闭宏编辑器,就看到结果在EXCEL的A列至E列了
Sub 十二选五()
Dim A, B, C, D, E, N, ARR(1 To 65536, 1 To 5)
For A = 1 To 8
For B = A + 1 To 9
For C = B + 1 To 10
For D = C + 1 To 11
For E = D + 1 To 12
N = N + 1
ARR(N, 1) = A
ARR(N, 2) = B
ARR(N, 3) = C
ARR(N, 4) = D
ARR(N, 5) = E
Next
Next
Next
Next
Next
[A1:E65536] = ARR
End Sub