Scenarios.Merge Method (Excel)
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.