本帖最后由 sunjing-zxl 于 2011-12-12 18:33 编辑
- Sub aa()
- Dim arr, arr1(), n As Long, m As Long, i As Long, j As Long
- Range("F1:H65536").ClearContents
- n = [A65536].End(xlUp).Row + 1
- arr = Range("A1:C" & n)
- ReDim arr1(1 To n, 1 To 3)
- m = 1
- For i = 1 To n
- If arr(i, 1) = "" Then
- For j = m To i
- arr1(m, 1) = IIf(arr1(m, 1) + arr(j, 1) = 0, "", arr1(m, 1) + arr(j, 1))
- arr1(m, 2) = IIf(arr1(m, 2) + arr(j, 2) = 0, "", arr1(m, 2) + arr(j, 2))
- arr1(m, 3) = IIf(arr1(m, 3) + arr(j, 3) = 0, "", arr1(m, 3) + arr(j, 3))
- Next j
- m = i + 1
- End If
- Next i
- Range("F1:H" & n) = arr1
- End Sub
复制代码 我来抽个热闹
|