|
本帖最后由 lhj323323 于 2011-5-25 20:51 编辑
老师:
上传的附件中有写好的程序,感觉应是对的,但是导出的组合却不是五位,不知我错在什么地方了
不够仔细,数组定义错误 - Sub 组合6()
- Dim i&, j&, k&, l&, m&, Ar1, Ar2, Ar3, Ar4, Ar5, Arr1(), r&
- Dim Myr%
- Application.ScreenUpdating = False
- '========根据用户对百十个位的杀号后的剩余球号进行组合=================
- Ar1 = Range("i16:i" & [i65536].End(xlUp).Row)
- Ar2 = Range("j16:j" & [j65536].End(xlUp).Row)
- Ar3 = Range("k16:k" & [k65536].End(xlUp).Row)
- Ar4 = Range("l16:l" & [l65536].End(xlUp).Row)
- Ar5 = Range("m16:m" & [m65536].End(xlUp).Row)
- For i = 1 To UBound(Ar1)
- For j = 1 To UBound(Ar2)
- For k = 1 To UBound(Ar3)
- For l = 1 To UBound(Ar4)
- For m = 1 To UBound(Ar5)
- r = r + 1
- '===========导入单列结果=====ok
- ReDim Preserve Arr1(1 To r)
- Arr1(r) = Ar1(i, 1) & " " & Ar2(j, 1) & " " & Ar3(k, 1) & " " & Ar4(l, 1) & " " & Ar5(m, 1)
- Next
- Next
- Next
- Next
- Next
- Stop
- Sheet2.Range("g2:g" & Sheet2.[g65536].End(3).Row).ClearContents
- Sheet2.[g2].Resize(r, 1) = Application.Transpose(Arr1) '导出单列
- Sheet2.[g1] = Array("排五组合")
- Erase Arr1 '清空数组
- Erase Ar1
- Erase Ar2
- Erase Ar3
- Erase Ar4
- Erase Ar5
- Application.ScreenUpdating = True
- Sheet2.Activate
- End Sub
复制代码
|
|