This documentation is archived and is not being maintained.

Scenario Object [Excel 2003 VBA Language Reference]

Office 2003

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


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

Parent Objects

Child Objects | Range Object