Solver

Hi Ben, thanks for your query. You can select non-contiguous ranges of cells for Solver to run on but this will come up with only one solution by modifying all those cells at once, and I'm not sure that's what you want. Solver doesn't provide a facility to run multiple instances one after another automatically and the only way to do this would be to record some macros. If you did that, you could attach those macros to command buttons on the spreadsheet and run them at the click of a button, or you could create a master macro which ran the lot.

Hope this helps,

Anthony