Hi all
I have a script that generates an array in VBA. The array is multidimensional, always 10 columns wide but is dynamic with the amount of rows. In the below example it is currently getting elements for 3 rows
What i would like to be able to do is run a script which will alter the elements in the array index that has the highest value in column 9. So in the above example MyVar(3) has the highest value in column 9 (0.17628...).
From there i would like a script to do, for example:
MyArr(3,2) = MyArr(3,2) x 2
MyArr(3,3) = MyArr(3,3) +1
etc.
Hope this make sense,
Many thanks in advance
I have a script that generates an array in VBA. The array is multidimensional, always 10 columns wide but is dynamic with the amount of rows. In the below example it is currently getting elements for 3 rows
What i would like to be able to do is run a script which will alter the elements in the array index that has the highest value in column 9. So in the above example MyVar(3) has the highest value in column 9 (0.17628...).
From there i would like a script to do, for example:
MyArr(3,2) = MyArr(3,2) x 2
MyArr(3,3) = MyArr(3,3) +1
etc.
Hope this make sense,
Many thanks in advance