|
发表于 2014-5-24 20:16
|
显示全部楼层
本楼为最佳答案
superle! 发表于 2014-5-24 19:34
不好意思,麻烦你了,还有一个问题,就是从第7行开始。,,因为从第2行到第6行都有是值的,但不是数值,我 ... - Private Sub CommandButton1_Click()
- Dim arrSrouce
- Dim arrTarget()
- Dim i%, j%, k%
- With Sheets("sheet1")
- arrSrouce = .Range(.Range("aa7"), .Range("aa7").End(xlDown).End(xlToRight))
- ReDim arrTarget(1 To UBound(arrSrouce), 1 To 13)
- For i = 1 To UBound(arrTarget)
- For j = 1 To UBound(arrTarget, 2)
- k = UBound(arrSrouce, 2) + 1
- arrTarget(i, j) = 0
- Do
- k = k - j
- If arrSrouce(i, k) >= 7 Then
- arrTarget(i, j) = arrTarget(i, j) + 1
- Else
- Exit Do
- End If
- Loop
- Next j
- Next i
- .Range("A7").Resize(UBound(arrTarget), UBound(arrTarget, 2)) = arrTarget
- End With
- End Sub
复制代码 需求最好一次说清,改来改去,大家麻烦
|
|