Hi all
I am in the process of trying to fill a matrix of cells from vba but am struggling to get it right.
Starting at cell B120 I have the numbers 1 to 50 in every other cell.
What I am trying to do is now populate columns starting at cell A121 with each of the possible combinations of the numbers 1 to 50, so I end up with a matrix of three number combinations eg cell b122 is 1(from the column):2:4(from the row)
Eg in cell a121 I need 2:3 then in cell a122 2:4 etc down to 50:49
In cell c121 I need 1:3 then in cell c122 1:4 etc
can anybody help?
Thanks duncan
I am in the process of trying to fill a matrix of cells from vba but am struggling to get it right.
Starting at cell B120 I have the numbers 1 to 50 in every other cell.
What I am trying to do is now populate columns starting at cell A121 with each of the possible combinations of the numbers 1 to 50, so I end up with a matrix of three number combinations eg cell b122 is 1(from the column):2:4(from the row)
Eg in cell a121 I need 2:3 then in cell a122 2:4 etc down to 50:49
In cell c121 I need 1:3 then in cell c122 1:4 etc
can anybody help?
Thanks duncan
