Separates the specified merged area into individual cells.
Syntax
expression.UnMerge
expression An expression that returns a Range object.
Remarks
When you separate a merged area, the value in the merged area is placed in the cell in the upper-left corner of the area. All other cells are cleared.