Represents a collection of merged cells in a worksheet.
public interface IXlMergedCells : IEnumerable<XlCellRange>, IEnumerable, ICollection
Public Interface IXlMergedCells Inherits IEnumerable(Of XlCellRange), IEnumerable, ICollection
Related API Members
The following members accept/return IXlMergedCells objects:
To access an object exposing the IXlMergedCells interface, use the IXlSheet.MergedCells property.
Use the collection’s IXlMergedCells.Add method to merge a specified range of cells into a single cell. To split a merged cell, remove it from the collection by using the IXlMergedCells.Remove or IXlMergedCells.RemoveAt method. To split all merged cells in a worksheet, use the IXlMergedCells.Clear method.
For an example on how to merge and unmerge worksheet cells, refer to the How to: Merge Cells or Split Merged Cells article.