Scenarios Members
Include Protected Members
Include Inherited Members
A collection of all the Scenario objects on the specified worksheet. A scenario is a group of input values (called changing cells) that’s named and saved.
The Scenarios type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
.gif "Public property") |
Application | Returns an Application object that represents the Microsoft Excel application. |
|
Count | Returns the number of objects in the collection. |
|
Creator | Returns a 32-bit integer that indicates the application in which this object was created. |
|
Parent | Returns the parent object for the specified object. |
Top
Methods
| Name | Description | |
|---|---|---|
.gif "Public method") |
Add | Creates a new scenario and adds it to the list of scenarios that are available for the current worksheet. |
|
CreateSummary | Creates a new worksheet that contains a summary report for the scenarios on the specified worksheet. |
|
GetEnumerator() | (Inherited from IEnumerable.) |
|
GetEnumerator() | |
|
Item | Returns a single object from a collection. |
|
Merge | Merges the scenarios from another sheet into the Scenarios collection. |
Top