Scenario Members
Include Protected Members
Include Inherited Members
Represents a scenario on a worksheet. A scenario is a group of input values (called changing cells) that’s named and saved.
The Scenario type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
.gif "Public property") |
Application | Returns an Application object that represents the Microsoft Excel application. |
|
ChangingCells | Returns a Range object that represents the changing cells for a scenario. |
|
Comment | Returns or sets the comment associated with the scenario. The comment text cannot exceed 255 characters. |
|
Creator | Returns a 32-bit integer that indicates the application in which this object was created. |
|
Hidden | True if the scenario is hidden. The default value is False. |
|
Index | Returns the index number of the object within the collection of similar objects. |
|
Locked | True if the object is locked; False if the object can be modified when the sheet is protected. |
|
Name | Returns or sets the name of the object. |
|
Parent | Returns the parent object for the specified object. |
|
Values | Returns an array that contains the current values of the changing cells for the scenario. |
Top
Methods
| Name | Description | |
|---|---|---|
.gif "Public method") |
ChangeScenario | Changes the scenario to have a new set of changing cells and (optionally) scenario values. |
|
Delete | Deletes the object. |
|
Show | Shows the scenario by inserting its values on the worksheet. The affected cells are the changing cells of the scenario. |
Top