点击文件名下载附件
Sub df() Dim Arr, i&, Ar(1 To 1000, 1 To 2), K&, j&, S&, U& Arr = Range([b2], [b2].End(4)).Value For i = 1 To UBound(Arr) If Arr(i, 1) = 0 Then S = 0 For j = i To UBound(Arr) If Arr(j, 1) = 0 Then S = S + 1 Else Exit For End If Next j i = i + S - 1 If S > 1 Then If U > 0 Then K = K + 1 Ar(K, 1) = U: U = 0 End If K = K + 1: Ar(K, 2) = S Else U = U + 1 End If End If Next i If U > 0 Then K = K + 1: Ar(K, 1) = U [e2].Resize(K, 2) = Ar End Sub
点击文件名下载附件
Sub df() Dim Arr, i&, Ar(1 To 1000, 1 To 2), K&, j&, S&, U& Arr = Range([b2], [b2].End(4)).Value For i = 1 To UBound(Arr) If Arr(i, 1) = 0 Then S = 0 For j = i To UBound(Arr) If Arr(j, 1) = 0 Then S = S + 1 Else Exit For End If Next j i = i + S - 1 If S > 1 Then If U > 0 Then K = K + 1 Ar(K, 1) = U: U = 0 End If K = K + 1: Ar(K, 2) = S Else U = U + 1 End If End If Next i If U > 0 Then K = K + 1: Ar(K, 1) = U [e2].Resize(K, 2) = Ar End Sub