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.