Scenario.ChangeScenario Method (Excel)
Changes the scenario to have a new set of changing cells and (optionally) scenario values.
Syntax
expression .ChangeScenario(ChangingCells, Values)
expression A variable that represents a Scenario object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
ChangingCells |
Required |
Variant |
A Range object that specifies the new set of changing cells for the scenario. The changing cells must be on the same sheet as the scenario. |
Values |
Optional |
Variant |
An array that contains the new scenario values for the changing cells. If this argument is omitted, the scenario values are assumed to be the current values in the changing cells. |
Return Value
Variant
Remarks
If you specify Values, the array must contain an element for each cell in the ChangingCells range; otherwise, Microsoft Excel generates an error.
Example
This example sets the changing cells for scenario one to the range A1:A10 on Sheet1.
Worksheets("Sheet1").Scenarios(1).ChangeScenario _
Worksheets("Sheet1").Range("A1:A10")