Scenario Object
| Excel Developer Reference |
Represents a scenario on a worksheet.
Remarks
A scenario is a group of input values (called
changing cells
) that’s named and saved. The Scenario object is a member of the Scenarios collection. The Scenarios collection contains all the defined scenarios for a worksheet.
Example
Use Scenarios(
index
), where
index
is the scenario name or index number, to return a single Scenario object. The following example shows the scenario named "Typical" on the worksheet named "Options."
| Visual Basic for Applications |
|---|
|
See Also