Running Solver on Multiple Rows

I am a little surprised that you found nothing, because there is a lot of examples of VBA code running Solver out there. Search engines, I guess, just sometimes fail to find stuff that is right under their noses.

A good starting tutorial for Solver in VBA: https://peltiertech.com/Excel/SolverVBA.html
Some examples from our forum: https://www.excelforum.com/excel-pro...ithin-vba.html
https://www.excelforum.com/excel-pro...e-columns.html
https://www.excelforum.com/excel-pro...lver-loop.html
There are many others.

I suggest you start there and see how far you get. Let us know where you get stuck, and we'll help you get over the bumps along the way.

Hi MrShorty,

Thank you for the reference links, there is a slight chance I just didn't know what I was looking for.

I recorded a macro setting up solver:

Please Login or Register  to view this content.

Now on to the part of automating solver through the next 826 rows. What would be a good starting point? I have tried to copy and paste the format from your examples, but am getting confused since they are different formulas.
Could you please help me out? I appreciate the response.

I'm sure we can help. However, this forum can get strict about rules, like putting code in code tags. You should edit your post to include those code tags.

I might also suggest that we look at this problem a little closer -- using our old favorite algebra instead of programming. At first glance, it appears to me that there ought to be an algebraic solution that will almost certainly be a lot easier to program into the spreadsheet than trying to loop Solver.

I see a system of 2 inequalities (column letters as variables):

1) 0.15G <= Z <= 0.35G
2) 0.85D <= G+Z <= 0.95D --> subtract G 0.85D-G <= Z <= 0.95D-G

At this point, the max value of Z that solves the first equation should be Z=0.35G and the max value that solves equation 2 should be Z=0.95D-G. It should be a simple decision (=IF()) step to decide which of the two possible solutions solves both inequalities.

I note that the problem in the OP does not seem to have a solution -- I cannot see a value for Z that fits in both ranges. The current value for Z appears to be the max value allowed by the first equation, and Y is still less than V. That could mean that I am not understanding the problem. What do you expect the solution for the problem in the OP to be?

It might be a number within the range of 15-35% that solves both equations though and that's why I would prefer to use Solver for this problem.

Do you have an example of a problem where the solution is not one of the endpoints of the allowed ranges? I recognize that the problem statement technically allows for a solution in between values, but it seems like the solution will always be at one of those endpoints.

As for getting started with the VBA, I'm not sure what parts of the formula are confusing. I would expect something like:

Please Login or Register  to view this content.

Note that all I have done was to put your Solver code into a For..Next loop, and replace the string constant references with variables that I can manipulate in the loop.