|
- Sub dayin()
- Dim ARR(1 To 1, 1 To 12)
- Set TJ = Sheets("统计表")
- Row1 = TJ.Range("A65536").End(xlUp).Row
- Erase ARR
- With Sheets("送货单")
- .PrintOut
- x = MsgBox("是否打印成功", 4, "打印")
- If x = vbYes Then
- ARR(1, 1) = .[g1]
- ARR(1, 2) = .[g4]
- ARR(1, 3) = .[b3]
- ARR(1, 4) = .[b4]
- ARR(1, 5) = .[a6]
- ARR(1, 6) = .[g3]
- ARR(1, 7) = .[b6]
- ARR(1, 8) = .[c6]
- ARR(1, 9) = .[d6]
- ARR(1, 10) = .[e6]
- ARR(1, 11) = .[g6]
- ARR(1, 12) = .[b8]
- For I = 3 To TJ.Range("A65536").End(3).Row
- If ARR(1, 1) = TJ.Range("A" & I) Then
- If MsgBox("该销售单号已存在,是否覆盖记录?", vbYesNo) = vbNo Then Exit Sub
- TJ.Range("A" & I).Resize(1, 12) = ARR
- GoTo 10
- End If
- Next
- TJ.Range("A" & Row1 + 1).Resize(1, 12) = ARR
- 10 .[g1] = TJ.Range("A65536").End(3) + 1
- .[b3] = ""
- .[a6].ClearContents
- .[g3].ClearContents
- .[b6].ClearContents
- .[c6].ClearContents
- .[d6].ClearContents
- .[e6] = ""
- .[g6].ClearContents
- .[b8] = ""
- End If
- End With
- End Sub
复制代码 |
|