Scenarios Methods (Excel)

Office 2013

Published: July 16, 2012

This object has the following 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.

Community Additions

ADD
Show:
© 2014 Microsoft