NextGameCounter, x and y are all integers. GoalieX is defined as an object.
AwayTeamPage is defined as a worksheet and is used several times earlier in
code without any issues.

i get the error message Method 'Range ' of object '_Worksheet' failed. i
don't get it.

For y = 1 To 9
Set GoalieX = AwayTeamPage.Range("GOALIE" & y)
For x = 1 To 3
AwayTeamPage.Range(GoalieX).Cells(4 + NextGameCounter, -3) =
AwayTeamPage.Range("g6").Cells(NextGameCounter, -1 + x)
Next x
Next y