Looping a Solver

Hi all,

I am trying to create an optimization macro and have created the following code:

Please Login or Register  to view this content.

As you can see, it's two parts of identical code, with only three cells changing. In total, I need to create 15 of such codes. I have understood that there is something as creating loops. Can these loops be created for a solver, and if so, how would it look like applied to my code? Thanks in advance,

Kind regards,

Peter