How to run X number of for loops

Hello, I'm trying to run a variable number of for loops. For example -

Please Login or Register  to view this content.

where the number of loops (i, j, k... in this case, 3) is variable.

More broadly, I'm trying to find out different combinations of sporting events and loop through assigned probabilities to see the probability of an outcome (i.e. home team wins i, away team wins j, home team wins k, etc...), and I don't know in advance how many sports games there will be (and there could be many).

Thanks for the help!

Use multi dimensional arrays with an incremented variable to access the second dimension, http://www.homeandlearn.org/multidim...al_arrays.html

Many different ways to do this. I will describe a few here:

If a sport has a named range for the probabilities called "Sport1_prob" in cells A1 to A5, you can cycle through that range with something like:

Please Login or Register  to view this content.

You can use the range directly if there is no named range

Please Login or Register  to view this content.

Alternately, in the same scenario above you can perform looping using the For...Each method

Please Login or Register  to view this content.

If you want to cycle through the probabilities in a list from A1 to A5 and the list may eventually expand unlimited down column A, you can use this method:

Please Login or Register  to view this content.

Note that the 1 (highlighted in red) indicates it is looking down column 1

Use any of the loop methods embedded within each other as you described in the post.

HTH,
Maud