Scenarios Scenarios Scenarios Interface


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.

public interface class Scenarios : System::Collections::IEnumerable
public interface Scenarios : System.Collections.IEnumerable
Public Interface Scenarios
Implements IEnumerable


Use the Scenarios(Object) method to return the Scenarios collection.

Use the Add(String, Object, Object, Object, Object, Object) method to create a new scenario and add it to the collection.

Use Scenarios(index), where index is the scenario name or index number, to return a single Scenario object.


Application Application Application

Returns an Application object that represents the Microsoft Excel application.

Count Count Count

Returns the number of objects in the collection.

Creator Creator Creator

Returns a 32-bit integer that indicates the application in which this object was created.

Parent Parent Parent

Returns the parent object for the specified object.


Add(String, Object, Object, Object, Object, Object) Add(String, Object, Object, Object, Object, Object) Add(String, Object, Object, Object, Object, Object)

Creates a new scenario and adds it to the list of scenarios that are available for the current worksheet.

CreateSummary(XlSummaryReportType, Object) CreateSummary(XlSummaryReportType, Object) CreateSummary(XlSummaryReportType, Object)

Creates a new worksheet that contains a summary report for the scenarios on the specified worksheet.

GetEnumerator() GetEnumerator() GetEnumerator()
Item(Object) Item(Object) Item(Object)

Returns a single object from a collection.

Merge(Object) Merge(Object) Merge(Object)

Merges the scenarios from another sheet into the Scenarios collection.

Applies to