Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is wrong with this range???
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
right code, wrong range | Excel Programming | |||
Range in wrong book | Excel Programming | |||
VBA Range error - How does this work and what am I doing wrong? | Excel Programming | |||
User input as a range. What am I doing wrong? | Excel Programming | |||
deleting wrong range! | Excel Programming |