|
- Private Sub 组合_Click()
- Dim Arr, i&, r%, S(), j&, i1&, i2&, i3&, i4&, i5&, x$, x3%, y3%
- Dim D, k, Brr()
- Set D = CreateObject("Scripting.Dictionary")
- Arr = Range(Cells(1, 1), Cells(106, 10))
- Debug.Print Range(Cells(1, 1), Cells(106, 10)).Address(False, False)
- For i = 1 To UBound(Arr)
- For j = 1 To UBound(Arr, 2)
- If Val(Arr(i, j)) > 0 Then
- r = r + 1
- ReDim Preserve S(1 To r)
- S(r) = Arr(i, j)
- End If
- Next
- r = 0
- If r >= 5 Then
- For i1 = 1 To r - 4
- For i2 = i1 + 1 To r - 3
- For i3 = i2 + 1 To r - 2
- For i4 = i3 + 1 To r - 1
- For i5 = i4 + 1 To r
- x = S(i1) & "," & S(i2) & "," & S(i3) & "," & S(i4) & "," & S(i5)
- D(x) = ""
- Next
- Next
- Next
- Next
- Next
- End If
- Next
- k = D.keys
- If D.Count > 0 Then
- ReDim Brr(1 To D.Count, 1 To 10)
- For i = 0 To UBound(k)
- aa = Split(k(i), ",")
- For j = 0 To UBound(aa)
- If aa(j) <> "" Then Brr(i + 1, aa(j)) = aa(j)
- Next
- Next
- Cells(144, 1).Resize(UBound(Brr), 10) = Brr
- 'D.RemoveAll
- else
- msgbox "没有有效数据"
- End If
- End Sub
复制代码 |
|