Item Method (Scenarios Collection)

Applies To

Scenarios collection object.

Description

Returns a single Scenario object from a Scenarios collection.

Syntax

expression.Item(Index)

expression Required. An expression that returns a Scenarios object.

Index Required Variant. The name or index number of the scenario.

Example

This example shows the scenario named "Typical" on the worksheet named "Options."

Worksheets("Options").Scenarios.Item("Typical").Show