NativeExcel for .Net Developer's Reference

IRange.UnMergeMethod

Separates a merged area into individual cells.

[Visual Basic]
SubUnMerge()
[C#]
voidUnMerge();
[C++]
voidUnMerge();
[JScript]
functionUnMerge();

Example

This example separates the merged range A1:F2.

[C#]
 book.Worksheets[1].Range["A1:F2"].UnMerge();
[VisualBasic]
 book.Worksheets(1).Range("A1:F2").UnMerge()
[C++]
 book->Worksheets->Item[1]->Range->Item[S"A1:F2"]->UnMerge();

See Also

IRange Interface | NativeExcel Namespace | Merge Method | MergeCells Property | MergeArea Property