Range.Merge method (Excel)

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.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.