|
求大虾用vba解决,附上附件一份,谢谢
- Sub Macro1()
- Dim arr, brr, crr, i&, j%
- arr = [a1:f17]
- ReDim brr(1 To 20000, 1 To 6)
- ReDim crr(1 To 20000, 1 To 6)
- For i = 1 To UBound(arr)
- s = 0
- For j = 2 To UBound(arr, 2)
- If arr(i, j) - arr(i, j - 1) = 1 Then s = s + 1
- Next
- If s = 1 Then
- n = n + 1
- For j = 1 To UBound(arr, 2)
- brr(n, j) = arr(i, j)
- Next
- End If
- If s = 0 Then
- n2 = n2 + 1
- For j = 1 To UBound(arr, 2)
- crr(n2, j) = arr(i, j)
- Next
- End If
- Next
- If n Then Range("i1").Resize(n, 6) = brr
- If n2 Then Range("q1").Resize(n2, 6) = crr
- End Sub
复制代码
|
|