I would suggest you stop and fix the errors. There are a lot of undefined variable errors.
You have code like this
Code:
Dim a, b, d, h, h1, h2, w As Integer
Dim i, ii, iii As Integer
Lines like this do not do what you think they do.
Variables a, b, d, h, h1, h2 are defined as Variant and only w is defined as an Integer
Likewise variables i, ii are defined as Variant and only iii is defined as an Integer.
In VBA, you MUST EXPLICITLY define each variable.
Code:
Dim a As Integer, b As Integer, d As Integer, h As Integer, h1 As Integer, h2 As Integer, w As Integer
Dim i As Integer, ii As Integer, iii As Integer
EVERY code module should have these two lines at the top:
Code:
Option Compare Database
Option Explicit
In most code pages, the line "Option Explicit" is missing.
In table "tblLeague", there are two fields named "Date" and "Time". "Date" and "Time" are reserved words and built in functions and shouldn't be used for object names.
Plus they are not descriptive. "Date" and "Time" of what??
My 2 cents.......