- Sub 入库()
- Dim x&, y&, Arr, Brr(), d1, d2, Row2, d3, d4, br()
- Sheet1.Activate
- With Sheet1
- Row2 = Sheet2.Range("a65536").End(xlUp).Row
- d1 = .[P4]: d2 = .[H15]: d3 = .[d15]: d4 = .[c4]
- Arr = .Range("b8").CurrentRegion
- ReDim Brr(1 To UBound(Arr), 1 To 14)
- For x = 1 To 3
- If Arr(x, 1) <> "" Then
- Brr = Array(d2, Arr(x, 5), d1, Arr(x, 1), Arr(x, 3), Arr(x, 4), Arr(x, 8), Arr(x, 10), Arr(x, 14), Arr(x, 15), Arr(x, 16), d3, , d4)
- m = m + 1
- For y = 1 To 14
- br(m, y) = Brr(x, Brr(y))
- Next
- End If
- Next
- If m > 0 Then Sheet2.Range("a" & Row2 + 1).Resize(m, 14) = br
- End With
- Application.ScreenUpdating = True
- End Sub
复制代码
下标越界.rar
(11.17 KB, 下载次数: 3)
|