|
发表于 2017-5-29 17:18
|
显示全部楼层
本楼为最佳答案
- Sub aaa()
- Dim y, ar, i&, s1, s2, j&, n, m, br, p
- y = Range("a65536").End(3).Row
- ar = Range("a11:f" & y)
- s1 = [H11]
- s2 = [J11]
- q = 11
- For i = 1 To UBound(ar)
- n = 0
- p = 1
- For j = 2 To UBound(ar, 2)
- If ar(i, j) - ar(i, j - 1) = 1 Then
- n = n + 1
- End If
- Next j
- If n = s1 Or n = s2 Then
- ReDim br(1 To UBound(ar, 2))
- For m = 1 To UBound(ar, 2)
- br(p) = ar(i, m)
- p = p + 1
- Next m
- Range("l" & q).Resize(1, UBound(br)) = br
- q = q + 1
- End If
- Next i
- End Sub
复制代码
|
评分
-
查看全部评分
|