Scenario Object Members

Excel Developer Reference

Represents a scenario on a worksheet.

Methods

	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.

Properties

	Name	Description
	Application	When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
	ChangingCells	Returns a Range object that represents the changing cells for a scenario. Read-only.
	Comment	Returns or sets a String value that represents the comment associated with the scenario.
	Hidden	Returns or sets a Boolean value that indicates if the scenario is hidden.
	Index	Returns a Long value that represents the index number of the object within the collection of similar objects.
	Locked	Returns or sets a Boolean value that indicates if the object is locked.
	Name	Returns or sets a String value representing the name of the object.
	Parent	Returns the parent object for the specified object. Read-only.
	Values	Returns a Variant array that contains the current values of the changing cells for the scenario.