Scenarios Methods (Excel)

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Methods

Name

Description

Add

Creates a new scenario and adds it to the list of scenarios that are available for the current worksheet.

CreateSummary

Creates a new worksheet that contains a summary report for the scenarios on the specified worksheet. Variant.

Item

Returns a single object from a collection.

Merge

Merges the scenarios from another sheet into the Scenarios collection.