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