Share via

_Worksheet.Scenarios Method

  • Article

Returns an object that represents either a single scenario (a Scenario object) or a collection of scenarios (a Scenarios object) on the worksheet.

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

Syntax

'Declaration
Function Scenarios ( _
    Index As Object _
) As Object
'Usage
Dim instance As _Worksheet
Dim Index As Object
Dim returnValue As Object

returnValue = instance.Scenarios(Index)

Object Scenarios(
    Object Index
)

Parameters

  • Index
    Type: System.Object

    Optional Object. The name or number of the scenario. Use an array to specify more than one scenario.

Return Value

Type: System.Object

See Also

Reference

_Worksheet Interface

_Worksheet Members

Microsoft.Office.Interop.Excel Namespace