Thank-you very much. It gave me the framework I needed to make it work....

I need to find all iterations/combinations and calculate the average value for each one. It is part of a randomization program in which I compare an observed average to a set of permuted averages, in this case an exact permutation in which I calculate the average for all possible combinations of the data....

I need help programming in Visual Basic 6.3 in Excel.
Here is what I am trying to do:
I have an array with x rows and y columns: Exact(x,y). I want to select all possible combinations of one cell from each row and then calculate the average. In other words, a value of y for each x. For example if there are 3 rows and 4 columns, the combinations would be:
1 1 1 (1st cell from row 1, 1st cell from row 2, 1st cell from row 3)...