UnmergeCells Method
Unmerges the specified range.
Syntax
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];.