Hyello,
I can attempt to answer a specific question about excel/vba but not solve an equation ,, you could try recording a macro to fill in the blanks or make a worksheet formula of the problem.
Can you expnad and ask a specific question?
Hi Pike!
Now that the nonblanks have been populated into array variables, how would I insert that variable into the following equation?:
CurrentValue = StartingValue * myArray(1) * PercentChange + StartingValue * myArray(2) * PercentChange + ..... StartingValue * myArray(n) * PercentChange
For n iterations of the array?