Merge Method

See Also         Example         Applies To

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.