Hi everyone,
I recently found, downloaded and used the Swiss chess tournament found on this site from 2015 (because I am new, I am unable to post the link.
I started using it and enjoyed how it took all of the work out of organising games that I was doing. Unfortunately, I started running into an error when trying to save a round so that I could generate the next one. Excel popped up with a VBA error labeled: 'Run-time error '1004': Application-defined or object-defined error'. The options on the error box were to end or debug (continue was not an option).
When I clicked debug it opened up 'supplementary code' in visual basic and took me to a line of code highlighted in yellow (here highlighted by underlining)
Sub SortStatistics()
With Sheets("Statistics")
.Range("F3").Resize(numPlayers, numPlayers + 4).Sort key1:=.Range("G3"), order1:=xlDescending, Header:=xlNo
End With
End Sub
I checked this code against another file I had been using to see if it differed, but it hadn't. Being that I don't know how to programme something like this I naturally came back to ask for help in debugging this.
Thanks in advance for any help that could be offered.
Bookmarks