Scenario Object

Description

Represents a scenario on a worksheet. A scenario is a group of input values (called changing cells) that's named and saved. The Scenario object is a member of the Scenarios collection. The Scenarios collection contains all the defined scenarios for a worksheet.

Using the Scenario Object

Use Scenarios(index), where index is the scenario name or index number, to return a single Scenario object. The following example shows the scenario named "Typical" on the worksheet named "Options."

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

Properties

Application property, ChangingCells property, Comment property, Creator property, Hidden property, Index property, Locked property, Name property, Parent property, Values property.

Methods

ChangeScenario method, Delete method, Show method.