在吗?向您请教一个问题,excel表格合同编号每打印一次,合同编号自动递增,怎样设定公式的
参考资料:
Sub WorksheetPrint()
'打印时,每个工作表的流水号(在C1单元格内)分别递增
Dim wb As Worksheet
For Each wb In Worksheets
wb.Range("C1") = wb.Range("C1") + 1
wb.PrintOut
Next
End Sub
热门标签:
参考资料:
Sub WorksheetPrint()
'打印时,每个工作表的流水号(在C1单元格内)分别递增
Dim wb As Worksheet
For Each wb In Worksheets
wb.Range("C1") = wb.Range("C1") + 1
wb.PrintOut
Next
End Sub