Share via


Scenario Object

Excel Developer Reference

Represents a scenario on a worksheet.

Remarks

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.

Example

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."

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

See Also