|
- Sub lqxs()
- Dim Arr, i&, r%, Arr1(), n&, j&, ks, js
- Dim m&, a, b
- Sheet1.Activate
- [d4:f100].ClearContents
- Arr = [a1].CurrentRegion
- For i = 2 To UBound(Arr)
- If Arr(i, 2) = 0 Then
- n = n + 1
- Else
- If n > 1 Then
- r = r + 1
- ReDim Preserve Arr1(1 To 2, 1 To r)
- Arr1(1, r) = i - 1
- Arr1(2, r) = n
- End If
- n = 0
- End If
- Next
- If n > 1 Then
- r = r + 1
- ReDim Preserve Arr1(1 To 2, 1 To r)
- Arr1(1, r) = i - 1
- Arr1(2, r) = n
- End If
- If r < 2 Then Exit Sub
- m = 3
- For i = 1 To r
- a = 0: b = 0
- js = Arr1(1, i + 1) - Arr1(2, i + 1)
- ks = Arr1(1, i) + 1
- For j = ks To js
- If Arr(j, 2) = 0 Then
- a = a + 1
- Else
- b = b + 1
- End If
- Next
- m = m + 1
- Cells(m, 4) = js + 1
- Cells(m, 5) = b
- Cells(m, 6) = a
- Next
- End Sub
复制代码 |
|