Share via


Scenarios.Merge Method

Excel Developer Reference

Merges the scenarios from another sheet into the Scenarios collection.

Syntax

expression.Merge(Source)

expression   A variable that represents a Scenarios object.

Parameters

Name Required/Optional Data Type Description
Source Required Variant The name of the sheet that contains scenarios to be merged, or a Worksheet object that represents that sheet.

Return Value
Variant

Remarks

The value of a merged range is specified in the cell of the range's upper-left corner.

See Also