PrintOut Loop

[Rostuse]

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.

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

 

[GWteB]

You are welcome and thanks for letting me know.

 

[Rostuse]

You are welcome and thanks for letting me know.

If it isn't too much to ask, is it possible instead of from X to Y, Y to be lets say 10, and X changes 10 times?
Example: X=100, Y=5,
X changes 5 times +1.

Its perfect even like this, do not worry if its too much to change.

Thanks again !