-
Notifications
You must be signed in to change notification settings - Fork 1
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. |
Getting Started
How-to Topics
- Solver Primer
- A Walkthrough Example
- Using the Enhanced Callback
- Using SolverWrapper Events
- ActiveX DLL FAQ
- Using Without Registration
Object Model Overview