Variables and Multiple Selections

The Solver Parameters dialog initially displays just one Changing Cells edit box to specify the decision variables in a model. This edit box accepts cell ranges, which may be typed in as cell coordinates (or as range names equivalent to cell coordinates), or entered by clicking the Range Selector button and selecting the desired cells in the spreadsheet. However, in many Solver models it is convenient to lay out the decision variable cells in several different ranges on the spreadsheet An example is the "Maximizing Income" worksheet in the SOLVSAMP.123 workbook.