Reference>IXLSRange>Unmerge

Separates a merged area into individual cells.

Syntax

procedure UnMerge;

This example separates the merged range A1:F2.

Workbook.Sheets[1].Range['A1', 'F2'].UnMerge;