If this has been asked and answered, I apologize. I've attempted to search for the answer to this question and was unable to locate a solution.
I have an array called arrGoodCombo. It will be only a single row containing 17 values. The first (1, 2, 3 4) , second (5, 6. 7, 8), third (9, 10, 11, 12) and fourth (13, 14, 15, 15) set of values will contain unique player numbers ranging from 1 - 20. The 17th position will hold a cumulative total value which is used to help determine best selection of test to post to a schedule.
My dilemma has been figuring out how to place each of the different sets of values in arrGoodCombo into a specific range within excel. While I know this is not the appropriate way to do it, this is effectively what I'm trying to accomplish.
Worksheets("Quarterly Schedule").Range("C8:F8").Value = arrGoodCombo(1, 2, 3, 4)
Worksheets("Quarterly Schedule").Range("H8:K8").Value = arrGoodCombo(5, 6, 7, 8)
Worksheets("Quarterly Schedule").Range("M8:P8").Value = arrGoodCombo(9, 10, 11, 12)
Worksheets("Quarterly Schedule").Range("R8:U8").Value = arrGoodCombo(13, 14, 15, 16)
Might there be an easy solution? Thanks for any help or guidance you can provide.
Don
I have an array called arrGoodCombo. It will be only a single row containing 17 values. The first (1, 2, 3 4) , second (5, 6. 7, 8), third (9, 10, 11, 12) and fourth (13, 14, 15, 15) set of values will contain unique player numbers ranging from 1 - 20. The 17th position will hold a cumulative total value which is used to help determine best selection of test to post to a schedule.
My dilemma has been figuring out how to place each of the different sets of values in arrGoodCombo into a specific range within excel. While I know this is not the appropriate way to do it, this is effectively what I'm trying to accomplish.
Worksheets("Quarterly Schedule").Range("C8:F8").Value = arrGoodCombo(1, 2, 3, 4)
Worksheets("Quarterly Schedule").Range("H8:K8").Value = arrGoodCombo(5, 6, 7, 8)
Worksheets("Quarterly Schedule").Range("M8:P8").Value = arrGoodCombo(9, 10, 11, 12)
Worksheets("Quarterly Schedule").Range("R8:U8").Value = arrGoodCombo(13, 14, 15, 16)
Might there be an easy solution? Thanks for any help or guidance you can provide.
Don