Help with Macro and Solver in Quattropro.

[John Killey]

I am trying to write a macro in Quattropro that uses the solver but there is
very little help out there that I can find. Any input would be most welcome.

TO simplify the problem, imagine the worksheet as follows:

I have a set of data on 10 rows and three columns. The real problem has more
like 800 rows and 50 columns so will take a long time to run. I want to
solve the problem for every occurrence of a data set, that is for every row.
I want to start in row one and solve with data in that row, go to row 2
solve with data in that row and so on. So obviously I need a do loop, that’s
the easy part. Within the loop I need to use toe solver. That’s the harder
part to write into VBA

The formula is on column A (the Target Cell in solver language), the value
cell is in column 2 (I need to input a value that changes with each row and
cannot use the max / min alternative that solver offers), I want to put the
Value in column 3, and there are no constraints to set. The default options
of solver can apply here. A problem I see is that the solver window does not
allow for a range to be put into the value but only allows a singe number to
be keyed in. I did find a looping macro at a Microsoft site but haven’t been
able to adapt it. Any ideas on writing the macro?