|
发表于 2012-8-22 09:47
|
显示全部楼层
本楼为最佳答案
楼主 看看这样是不是符合你的题意- Private Sub Workbook_BeforePrint(Cancel As Boolean)
- If ActiveSheet.Name = "送货单" Then
- With Sheets("库存")
- a = Range("j5").End(4).Row - 5
- b = IIf(.Range("a3") = "", 2, .Range("a3").End(4).Row)
- For i = 1 To a
- .Cells(b + i, 1) = Range("g3"): .Cells(b + i, 2) = Range("j4"): .Cells(b + i, 3) = Range("b3")
- .Cells(b + i, 7) = Round(Cells(5 + i, 6), 4): .Cells(b + i, 8) = Cells(5 + i, 9)
- .Cells(b + i, 9) = Cells(5 + i, 10): .Cells(b + i, 10) = Cells(5 + i, 2)
- Next
- End With
- End If
- End Sub
复制代码 |
|