本帖最后由 k6776545 于 2016-6-21 17:21 编辑
重新发了一个 求帮忙,添加个按钮打印Sheet2,把Sheet3的C2,C3,C4:E4,C5,C6,C7:E7,C8:E8,C9,E9,E6,E5,E3,G3:I3,G4:I4,G5:I5,G6,G7,G8:I8,G9:I9,I7,I6成行保存到Sheet1并清空
代码如下,我用的是你的sheet1,sheet2你工作表保护了,可以自己修改参数: - Private Sub CommandButton1_Click()
- With Sheet1
- n = Sheet3.Cells(Sheet3.Rows.Count, 1).End(xlUp).Row
- Sheet3.Cells(n + 1, 1) = n
- Sheet3.Cells(n + 1, 2) = .[c3]
- Sheet3.Cells(n + 1, 3) = .[D3]
- Sheet3.Cells(n + 1, 4) = .[C4]
- Sheet3.Cells(n + 1, 5) = .[G4]
- Sheet3.Cells(n + 1, 6) = .[C5]
- .Range("C2,C3,C4:E4,C5,C6,C7:E7,C8:E8,C9,E9,E6,E5,E3,G3:I3,G4:I4,G5:I5,G6,G7,G8:I8,G9:I9,I7,I6").ClearContents
- .PrintOut Copies:=1, Collate:=True
- End With
- End Sub
复制代码
|