- Sub test()
- Dim arr, i, j
- Dim brr(1 To 1000, 1 To 2)
- arr = Sheets(1).Range("B8").CurrentRegion
- For i = 2 To UBound(arr)
- For j = 6 To 10
- If arr(i, j) <> "" Then
- k = k + 1
- brr(k, 1) = arr(i, 1)
- brr(k, 2) = arr(i, 2)
- End If
- Next
- Next
- Sheets(2).Range("b5").Resize(k, 2) = brr
- End Sub
复制代码 |