For Loops and Arrays

Good Morning,

I am having a problem creating a for loop that iterates through a range of values while doing a function on every row.

The problem at hand:
If I have some function - Performance = ( 1 - (Part1IdealRate * Part1PartsProduced) ) + ( 1 - (Part2IdealRate * Part2PartsProduced) ) + ...etc how would I go about applying this?
My initial attempt involved just iterating over the entire range and applying the formula onto the rows, specifying the cells such that

Please Login or Register  to view this content.

This value is then send to an array

Please Login or Register  to view this content.

Then the array is redimmed

Please Login or Register  to view this content.

Everytime I run this it yields an error at the Redim - Error 9: Subscript out of range .

Heres the entire portion of the code:

Please Login or Register  to view this content.

Any help would be appreciated thanks!

You need to specify Lower bound.

Please Login or Register  to view this content.

Thank you very much, I was struggling to figure out my problem

You are welcome and thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Can you explain what you expect the below line to do?

Please Login or Register  to view this content.

I thought I needed that in order to apply the inner function I have to the Array - I have realized now though that essentially removing the WorksheetFunction "SumProduct" now accomplishes the same thing just sans summing the result value.