Sub 保存() Dim Arr, bR_n&, i% Arr = Range("B12:I15") For i = 1 To 4 If Arr(i, 1) = "" Then Exit Sub With Sheets("入库明细") bR_n = .[b65536].End(xlUp).Row + 1 .Cells(bR_n, 2).Resize(1, 5) = Array([H9], [H7], [C8], [C7], [C9]) .Cells(bR_n, "G").Resize(1, 8) = Application.Index(Arr, i) End With Next Sheets("入库明细").Range("B2:P" & bR_n).Borders.LineStyle = xlContinuous End Sub
DbvWHAKP.rar
(17.83 KB, 下载次数: 21)
|