Merge(The value of a merged range is specified in the cell of the range's upper-left corner: OleVariant);

OleVariant. True to merge cells in each row of the specified range as separate merged cells This example merges A1:F1 cells on sheet one

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

'A1'

This example merges A1:F1 cells on sheet one

].Range[

'F1'

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