Scenarios Methods

Name

Returns

Description

Add

Scenario

Method. Parameters: Name As String, ChangingCells, [Values], [Comment], [Locked], [Hidden]. Adds a scenario to the collection. The Name parameter specifies the name of the scenario. See the Scenario object for a description of the parameters

CreateSummary

Variant

Method. Parameters: ReportType As XlSummaryReport-Type, [ResultCells]. Creates a worksheet containing a summary of all the scenarios of the parent worksheet. The ReportType parameter can specify the report type. The ResultCells parameter can be a range of cells containing the formulas related to the changing cells

Merge

Variant

Method. Parameters: Source. Merges the scenarios in the Source parameter into the current worksheet

0 0

Post a comment