This documentation is archived and is not being maintained.

Scenario Members 

Represents a scenario on a worksheet. A scenario is a group of input values (called changing cells) that’s named and saved.

The following tables list the members exposed by the Scenario type.

  Name Description
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.

  Name Description
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.