- Sub qcw()
- Application.ScreenUpdating = False
- N = 1
- arr = Sheet2.Range("A5:I" & Sheet2.Range("a65536").End(3).Row)
- ReDim brr(1 To UBound(arr), 1 To 11)
- For i = 1 To UBound(arr)
- For J = 2 To 9
- brr(i, J) = arr(i, J)
- Next J
- brr(i, 1) = Sheet1.Range("a" & Sheet1.Range("a65536").End(3).Row) + N
- N = N + 1
- brr(i, 10) = Sheet2.Range("H3")
- brr(i, 11) = Sheet2.Range("H2")
- Next i
- Sheet1.Range("a" & Sheet1.Range("a65536").End(3).Row + 1).Resize(UBound(arr), 11) = brr
- Application.ScreenUpdating = True
- End Sub
复制代码 |