Iterate to create formula

[Chaba]

Hello,

Is there any way to iterate in a macro to create a formula on the spreadsheet so that the formula input would be added to depending on the number of replicates?. Something like =(Iteration 1 + Iteration 2 + ...). For example:

Please Login or Register  to view this content.

The macro would know how many iterations there would be (based on user input), but it would be different in different circumstances. I couldn't find anything like this online, so I'm not sure if it is even possible. Thanks for any help or suggestions.

[natefarm]

You would have to have a loop that built the formula string, such as:

Please Login or Register  to view this content.