VB 设置纸张
Suba()c=InputBox("请输入开始序号")b=InputBox("结束序号")Fori=cTobSheets("sheet1").Cells(2,8)=She...
Sub a()
c = InputBox("请输入开始序号")
b = InputBox("结束序号")
For i = c To b
Sheets("sheet1").Cells(2, 8) = Sheets("sheet1").Cells(2, 8) + 1
Sheets("sheet1").Cells(5, 2) = Sheets("sheet2").Cells(1 + i, 3)
Sheets("sheet1").Cells(6, 4) = Sheets("sheet2").Cells(1 + i, 2)
PrintOut
Next i
End Sub
我的代码怎么打出来的都是按A4纸,我的是针式打印机,打印票据,这个代码打出来一张,然后跳过一张,再打一张,再跳过一张.......,怎么设置它不跳过 展开
c = InputBox("请输入开始序号")
b = InputBox("结束序号")
For i = c To b
Sheets("sheet1").Cells(2, 8) = Sheets("sheet1").Cells(2, 8) + 1
Sheets("sheet1").Cells(5, 2) = Sheets("sheet2").Cells(1 + i, 3)
Sheets("sheet1").Cells(6, 4) = Sheets("sheet2").Cells(1 + i, 2)
PrintOut
Next i
End Sub
我的代码怎么打出来的都是按A4纸,我的是针式打印机,打印票据,这个代码打出来一张,然后跳过一张,再打一张,再跳过一张.......,怎么设置它不跳过 展开
1个回答
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询