Code to increment cell value between 2 given values and then print

Good afternoon all,

I have a game scoresheet that draws team info from another worksheet which holds the competition draw based on the game number.
I need to go through and print out a heap of scoresheets (over 100) but want to print them in batches dependent on where we are at in the competition. (eg Round 1 will be games 1 to 20.)

I have tried the below code to do the following:

Asks for the first game number to print
Asks for the last game number to print
Goes through and gradually increments cell A5 by 1 each time, prints the sheet and to stop once it prints the value entered into the last game number.

So as an example, if I enter the Start Game to be game 2, and end Game to be game 5, I want the value in cell A5 to start at 2, get printed, increment to 3, get printed, and so on until it prints out a sheet with cell A5 having the value of 5.

I have attached an example sheet using a basic vlookup to show when the values change as a test environment.

I am running into trouble where I cannot get the number in cell A5 to gradually increment.

Any help would be greatly appreciated.

Please Login or Register  to view this content.

Thank you Ed_Collins ..... I am just starting to experiment with VBA and such a simple thing had thrown me.
That worked perfectly.

Do you happen to know the code to select the next item in a data validation list?
Another part of my workbook is to print out a copy of the draw for each team and highlight their games. I have put the teams in a data validation list selected in cell B40. The list of team names is in cells X4:X23

In short i just want to insert a button and apply a macro to it that means I can hit the button and it will select the first team, print the draw, then drop down to the next team and print the draw, and so on for the whole 20 teams without me having to manually select the team each time.

This process just highlights their own team using Conditional formatting so they can see where they have to play in the draw.

Fantastic thanks again .. .worked a treat