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
Public property Application Returns an Application object that represents the Microsoft Excel application.
Public property ChangingCells Returns a Range object that represents the changing cells for a scenario.
Public property Comment Returns or sets the comment associated with the scenario. The comment text cannot exceed 255 characters.
Public property Creator Returns a 32-bit integer that indicates the application in which this object was created.
Public property Hidden True if the scenario is hidden. The default value is False.
Public property Index Returns the index number of the object within the collection of similar objects.
Public property Locked True if the object is locked; False if the object can be modified when the sheet is protected.
Public property Name Returns or sets the name of the object.
Public property Parent Returns the parent object for the specified object.
Public property Values Returns an array that contains the current values of the changing cells for the scenario.

Top

Methods

  Name Description
Public method ChangeScenario Changes the scenario to have a new set of changing cells and (optionally) scenario values.
Public method Delete Deletes the object.
Public method Show Shows the scenario by inserting its values on the worksheet. The affected cells are the changing cells of the scenario.

Top

See Also

Reference

Scenario Interface

Microsoft.Office.Interop.Excel Namespace