|
- Sub 新增()
- Range("h2") = Format(Date, "yyyy-mm-dd")
- If Format(Date, "yyyy") > Mid(Range("h3"), 3, 4) Then
- n = "001"
- Else
- n = Format(Right(Range("h3"), 3) + 1, "000")
- End If
- Range("h3") = "PK" & Format(Date, "yyyymmdd") & n
- r = Range("b65536").End(3).Row
- Range("a6:h" & r - 5).ClearContents
- End Sub
- Sub 保存()
- Dim arr(), r&, i&
- r = Range("a65536").End(3).Row
- ReDim arr(1 To r - 5, 1 To 12)
- For i = 1 To r - 5
- arr(i, 1) = Range("c2")
- arr(i, 2) = Range("h2")
- arr(i, 3) = Range("c3")
- arr(i, 4) = Range("h3")
- arr(i, 5) = Range("c4")
- For j = 2 To 8
- arr(i, j + 4) = Cells(i + 5, j)
- Next
- Next
- With Sheets("汇总入库单记录")
- r = .Range("a65536").End(3).Row + 1
- .Cells(r, 1).Resize(i - 1, 12) = arr
- .Cells(r, 1).Resize(i - 1, 12).Borders.LineStyle = xlContinuous
- End With
- MsgBox "OK!保存完毕!"
- End Sub
- Sub 打印()
- r = Range("b65536").End(3).Row
- With ActiveSheet.PageSetup
- Range("A1:H" & r).PrintPreview '设置'打印区域预览
- ' Range("A1:H" & r).PrintOut '设置'打印区域预览
- .BlackAndWhite = True '单色打印
- End With
- End Sub
复制代码 |
|