Remarks

A scenario is a group of input values (called) that's named and saved. The Scenarioobject is a member of the collection. The Scenarioscollection contains all the defined scenarios for a worksheet.

Example

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

Visual Basic for Applications
Worksheets("options").Scenarios("typical").Show
Scenario Object

See also:

changing cells index index