Dears,
I'm making a simple macro for ZPL printer. (But I'm not so good with it, it is my first time actually)
I have a code of 9 lines that needs to be printed (2nd sheet)
On the 1st sheet I have a Code of the product and Serial Number, start from X and stop until X.
The macro I am trying to make is to print the first serial number inserted, after that add +1 on the same and print it all until it meets the Stop Until X number.
I will really appreciate for your help.
Thanks
I'm making a simple macro for ZPL printer. (But I'm not so good with it, it is my first time actually)
I have a code of 9 lines that needs to be printed (2nd sheet)
On the 1st sheet I have a Code of the product and Serial Number, start from X and stop until X.
The macro I am trying to make is to print the first serial number inserted, after that add +1 on the same and print it all until it meets the Stop Until X number.
VBA Code:
Sub Print_Loop()
Do Until Sheets("Foglio1").Range("A2") = Sheets("Foglio1").Range("A3")
Sheets("Foglio2").Range("A1:A9").PrintOut
MsgBox "Want to Continue?", vbOKCancel
Sheets("Foglio1").Range("A2") = Sheets("Foglio1").Range("A2") + 1
Loop
End Sub
I will really appreciate for your help.
Thanks