VBA Solver copy and paste solution for different cells

I have what I think is a simple problem.

In cell B2 I have a number. I allow this number to change to maximize the solution in AC3. I then want to paste this optimized value from B2 into C3.

Then I want to rerun the program. I want B2 to change again, but this time I want to maximize the solution in AC3 and paste the solution into C3. How can I do this for all the way up to AC32 and pasting the solution from each optimization into its correspond cell in column 3?

If I run solver and record the macro, I get this:

Please Login or Register  to view this content.

So I want this to loop from Ac3 to Ac32

Something like this perhaps (untested) ?

Please Login or Register  to view this content.

Not sure about your B2 value it stays the same during the loop? I would have thought it should change as well i.e. ("B" & i).

Alf