Syntax 1: Merges the scenarios from another sheet into the Scenarios collection.
Syntax 2: Merges the styles from another workbook into the Styles collection.
Syntax 3: Creates a merged cell from the specified Range object.
Syntax 1
expression.Merge(Source)
Syntax 2
expression.Merge(Workbook)
Syntax 3
expression.Merge(Across)
expression Required. An expression that returns a Scenarios object (Syntax 1), Styles object (Syntax 2), or Range object (Syntax 3).
Source Required Variant. The name of the sheet that contains scenarios to be merged, or a Worksheet object that represents that sheet.
Workbook Required Variant. A Workbook object that represents the workbook containing styles to be merged.
Across Optional Variant. True to merge cells in each row in the specified range as separate merged cells. The default value is False.
Remarks
The value of a merged range is the value specified for the cell in the upper-left corner of the merged range.