I'm doing a simulation in vba between two players playing badminton.
I've pretty much done all the coding to represent a game, set etc. however i wanted to record all the scores for each game on a spreadsheet in excel, however as i do not know how many games they are going to play in total i'm struggling to do this.
Firstly I have done ..
If points1 = 4 Or points2 = 4 Then
GamesPlayed = GamesPlayed + 1
For j = 1 To GamesPlayed
Worksheets("RESULTS").Cells(j + 9, 1).Value = GamesPlayed
Next j
End If
But this changes the previous value in the previous cell, when i want it to stay the same.
Any help would be appreciated!
Bookmarks