What is the automatic numbering function for excel printing times?

The first step, in excel, press ALT F11, a window will pop up

The second step, in the pop-up window, select Insert module in the menu

The third step, copy and paste the following

Sub dayin()
dim n as integer
n=inputbox("打印次数") *1
for i=1 to n
activesheet.PrintOut Copies:=1
[H2]= "NO:" & application.text(i,"0000000000")'这里是H2，改成自己需要的单元格，后面是数字格式，根据需要修改
next
End Sub

code, and then close the window

The fourth step, return to excel and click OK, enter the number of copies to print

Recommended tutorial: "excel basic tutorial"

The above is the detailed content of What is the automatic numbering function for excel printing times?. For more information, please follow other related articles on the PHP Chinese website!