Skip to content

SolvDecisionVars

Michael Waite edited this page Mar 15, 2026 · 2 revisions

A class to define the Decision variable, i.e. the cells that are changed in order to satisfy the Objective. Example usage:

Problem.DecisionVars.Add "E10:E14"
Problem.DecisionVars.Initialize 0.2, 0.2, 0.2, 0.2, 0.2
Class Method/Property Description
SolvDecisionVars Add Adds a cell(s) range that will be changed to achieve the desired result in the Objective cell - limited to 200 cells.
SolvDecisionVars CellRange Gets the Decision variable cell range.
SolvDecisionVars Count Gets the total number of Decision variables.
SolvDecisionVars Initialize Initializes Decision Variables to user-specified values - can be a constant to assign to all, or a list of values to assign to each variable.
SolvDecisionVars Remove Removes a cell or range of cells from the Decision variable set
SolvDecisionVars RemoveAll Removes all Decision variables.

Clone this wiki locally