Solver Loop

HELP

I am very new to Excel 2010, and fairly new to VBA.

I am trying to create a VBA loop to run the excel 2010 solver. Even when i record a macro while manually running the solver, when i go into the VBA code and try to run it from the editor, it has a 'compile' error on the line that starts with SolverOK.

If I want to set cells A3:A10 equal to cells B3:B10, while changing cells C3:C10, how can I write that code. I've tried several times but have not succeeded.

Here's the recorded macro for just the first iteration:

Sub Macro5()
'
' Macro5 Macro
'
'
SolverOk SetCell:="$A$3", MaxMinVal:=3, ValueOf:="$B$3", ByChange:="$C$3", _
Engine:=1, EngineDesc:="GRG Nonlinear"

SolverSolve
End Sub

WOW. I've spent HOURS trying to get this to work. And you've solved it in seconds. I can't thank you enough.

I will go back to forum rules and add CODE tags.

Thank you so much