|
具体VBA如下,在编辑时提示 Range("A3") = “No:" & I 错误,请问错误在哪里,应该怎么修改?还有个问题,我不需要输入起始编号,我想让他自动识别某个位置的编号进行加1的进程,打印次数的保留。
Sub pnt()
Dim Num1, Num2, I As Integer
Num1 = InputBox("请输入起始编号", "打印起始编号")
Num2 = InputBox("请输入打印次数", "打印次数")
With Sheets("sheet1")
For I = Num1 To Num1 * 1 + Num2 * 1
.Range("A3") = “No:" & I
.PrintOut
Next I
End With
End Sub
Sub pnt()
Dim Num1, Num2, I As Integer
Num1 = cells(1,1)
cells(1,1)=num1+1
Num2 = InputBox("请输入打印次数", "打印次数")
With Sheets("sheet1")
For I = Num1 To Num1 * 1 + Num2 * 1
.Range("A3") = “No:" & I
.PrintOut
Next I
End With
End Sub
|
|