automating multiple runs of solver across worksheets
Posted by Craig Martin on September 11, 2001 3:57 PM
I have 12 worksheets in a workbook, in each one I'm running solver with a slightly different set of constraints. I tried to record a macro where I clicked into each cell, selected solver (where the constraints are already entered), hit 'solve', hit 'ok', and went on to the next sheet. However, when I run the macro, it says there's an error at the command 'SolverOK'. How can I automate the 12 runs of solver in the different worksheets?