Idex Match in For Loop to alter Column data is taken from

[jap7675]

Good Morning,

I dont understand why this peice of code will not work for 'i'. I can loop the column very easily. But, with or without the column for loop, the 'i' for loop will not work.

For Col = 1 To 7
For i = 1 To 7
With Application.WorksheetFunction
Sheets("Summary").Cells(15, Col) = _
.Index(Sheets(iYear).Range("A3:G50"), .Match(Sheets("Summary").Range("B15"), Rng, 1), i)
End With
Next i
Next Col​

I basically want to populate a row of data from one sheet 'iYear' into the summary. iYear is a string already defined in the code, and does not need quotations etc...

Thanks,

 

[jap7675]

For a matter of fact, my Index Match also isnt working as it should! When i changce my lookup value, it will not search for it!