Hello All,

Based upon resources found on the internet (various forums, websites, communities) I did able to create one excel solver macro which automates the solver calculations. Each solver calculation involves setting target cell to zero by changing variable cell. both are single cell entities. And like that, it runs solver function 11 times and each time the variable cell changes.

For example, during the solver calculations, In the first calculation target cell is N7, and its changed to 0 by changing variable cell O38, now the first calculation produced one value in O38 cell.
Solver immediately starts calculating second calculation, and now its target cell is N8 while the variable cell is O38, and the cell is holding value generated after first calculation (it is the same cell from first calculation, with result from calculation 1). Now, second calculation completed, and O38 cell holds new value, while the previous value is erased.
What I did is I added spreadsheet code by right clicking the spreadsheet, the code basically does copy previous value in the cell to new location, but its not working with VBA macro. That means whatever automated calculations are performed after that the spreadsheet code copies the previous value to new location.

I did not able to do it correctly.

Please Login or Register  to view this content.
my Spreadsheet code:
Please Login or Register  to view this content.

What I have in my mind is,
How can create VBA macro, which is:
1. Performing first calculation in N7 with whatever value in cell 'O38'
2. takes pause 1 to 3 seconds
3. Find out value of 0 in range of cells 'N7:N16' or just check whether 'N7' become 0
4. If value is 0 in any cell in range of cells 'N7:N16' or just cell 'N7'
5. then copy value in cell O38 to another location lets say cell 'T3'
6. takes pause 1 to 3 seconds
7. Start performing second calculation with N8
8. repeat all the tasks 1 to 6
like that complete calculations for range of cells 'N7:N16'.
At the end of macro I shall have multiple values captured from cell O38 and stored in multiple cells in T column one after another.
Please help me, I'm in desperate need, or assist me with the resources. from which I can develop something.


Thank you!
Regards,
Ash.K