Sub DAYIN()
ActiveSheet.PrintOut
With Sheets("开票统计表")
W = .Range("D65536").End(3).Row + 1
N = Range("J4").Value
.Cells(W, "A") = Range("G4")
.Cells(W, "B") = Range("B4")
.Cells(W, "I") = Range("J4")
.Cells(W, "I") = N
Range("B6:B10").Copy .Cells(W, "C")
Range("D6:H10").Copy .Cells(W, "D")
Range("I6:I10").Copy .Cells(W, "J")
Range("J6:J10").Copy .Cells(W, "K")
End With
Range("J4") = Mid(N, 1, 1) & Format(Right(N, 7) + 1, "0000000")
Range("A6:J10").ClearContents
End Sub
哪里出了问题???大侠些 |