Running solver for many cells

Hi

I am trying to solve around 1000 cells at the same time. I came to know that this is possible by using macro but I have been unsuccessful to implement it.
I need the solution from AC3:AC1003, the constraints and formulas are already there. So I need to move to the next row after solving each one.
Another problem is that a part of the variables will be shared by all. So if I get a optimised value for the AC3 cell , when i get the optimised value for AC4 , AC3 value gets changed. I figured this can be fixed if I add a macro after each solve to copy its text value to another cell.

Can anyone help ? Thanks in advance

This thread has an example of solver in a loop: https://www.excelforum.com/excel-pro...e-columns.html and also links to another thread with another example of Solver in a loop. Study those examples.

This page has some general ideas and suggestions for calling Solver from VBA: https://peltiertech.com/Excel/SolverVBA.html

I would start with those, make sure you can work those examples, then let us know what parts you are having difficulty with in adapting to your specific spreadsheet.

I rechecked some stuff and it worked ! Just another thing , as you can see from the code BD3:BD8 is common to all the the cells. So after the loop is completed all the cells take up the value chosen by the variables of the last one. Is it possible to copy the value of the cell to some other location and add it inside the loop ?

Found a way never mind

You can use the .Value property of a cell (a range object: https://msdn.microsoft.com/en-us/VBA...e-object-excel ) to read and write a value from one cell to another. a Let statement like cells(i,30).value=cells(i,29).value would copy the value in the 29th column into the 30th column.

Be careful with unqualified properties/methods like this though (even your current code is using an unqualified cells(...).address method/property). Unqualified references will refer to whatever the activesheet is. Only you will know for sure, but if there is any possibility that you don't want to run on the activesheet, it will be necessary to specify what sheet and/or book so that Excel runs the code on the correct block of cells.