Indexing

[M&M]

Can anyone explain to me how the Column index works and the Row index numbers?

In general im having trouble implementing the index idea into my VBA in excel

 

[Toppers]

Perhaps an example of the code which is causing problems?