Range.Merge Method

Excel Developer Reference

Creates a merged cell from the specified Range object.

Syntax

expression.Merge(Across)

expression   A variable that represents a Range object.

Parameters

Name Required/Optional Data Type Description
Across Optional Variant True to merge cells in each row of the specified range as separate merged cells. The default value is False.

Remarks

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

See Also