UnmergeCells Method
Unmerges the specified range.
Syntax
[VB.NET] Public Sub UnmergeCells(ByVal Cells As String)
[C#] public void UnmergeCells(string cells);
Remarks
This method unmerges the range specified by Cells.
Either the entire range such as "A1:B3" or any part of the merged range will unmerge the entire range.
For instance:
Exceldoc1.MergeCells("A1:B3"); Exceldoc1.UnmergeCells("A1");Will unmerge the range, as will "A1:B3", "B2", etc.
To find information about existing merged ranges in the sheet see MergedRangeCount and MergedRange[i];.