Partager via


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.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
<InterfaceTypeAttribute()> _
<GuidAttribute("00020896-0000-0000-C000-000000000046")> _
Public Interface Scenarios _
    Inherits IEnumerable
'Usage
Dim instance As Scenarios
[InterfaceTypeAttribute()]
[GuidAttribute("00020896-0000-0000-C000-000000000046")]
public interface Scenarios : IEnumerable

Remarks

Use the Scenarios method to return the Scenarios collection.

Use the Add 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.

See Also

Reference

Scenarios Members

Microsoft.Office.Interop.Excel Namespace