- Sub test()
- Dim r%, i%, c%, j%
- Dim arr, brr
- With Worksheets("sheet1")
- r = .Cells(.Rows.Count, 1).End(xlUp).Row
- c = .UsedRange.Find(what:="*", LookIn:=xlValues, lookat:=xlWhole, searchorder:=xlByColumns, searchdirection:=xlPrevious).Column
- arr = .Range("a1").Resize(r, c)
- ReDim brr(1 To UBound(arr), 1 To UBound(arr, 2))
- For i = 1 To UBound(arr) Step 2
- n = 2
- For j = 2 To UBound(arr, 2)
- If arr(i, j) = "O2N" Then
- brr(i, 1) = arr(i, 1)
- brr(i + 1, 1) = arr(i, 2)
- brr(i, n) = arr(i, j)
- brr(i + 1, n) = arr(i + 1, j)
- End If
- Next
- Next
- End With
- With Worksheets("sheet2")
- .Range("a1").Resize(UBound(brr), UBound(brr, 2)) = brr
- End With
-
- End Sub
复制代码 |