Reference>IXLSRange>Merge :: Delphi + Excel

Creates a merged cell from the specified IXLSRange object.

Syntax

procedure Merge(Accros: OleVariant);

Accros

OleVariant. True to merge cells in each row of the specified range as separate merged cells.

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

This example merges A1:F1 cells on sheet one.

Workbook.Sheets[1].Range['A1', 'F1'].Merge(False);