- UID
- 153
- 帖子
- 2398
- 积分
- 34637
- 阅读权限
- 80
- 注册时间
- 2005-7-9
- 最后登录
- 2015-6-19
- 在线时间
- 6842 小时
|
VBA可以弄
Option Explicit
Sub TwoB()
Dim i1%, i2%, i3%, k%, MyArray(1 To 15) As String
MyArray(1) = "4 "
MyArray(2) = "14 "
MyArray(3) = "24 "
MyArray(4) = "34 "
MyArray(5) = "44 "
MyArray(6) = "8 "
MyArray(7) = "18 "
MyArray(8) = "28 "
MyArray(9) = "38 "
MyArray(10) = "48 "
MyArray(11) = "9 "
MyArray(12) = "19 "
MyArray(13) = "29 "
MyArray(14) = "39 "
MyArray(15) = "49 "
k = 1
For i1 = 1 To 15
For i2 = i1 + 1 To 15
For i3 = i2 + 1 To 15
Sheet1.Cells(k, 1).Value = MyArray(i1) + MyArray(i2) + MyArray(i3)
k = k + 1
Next i3
Next i2
Next i1
End Sub |
|