如何设置流水号,使其每打印完一次,流水号可以自动连号生成

2025-04-01 08:49:23
推荐回答(1个)
回答1:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
js = Range("B10").Value
js = js + 1
Range("B10").Value = js
End Sub