XlCellInsertionMode Enumeration
Specifies the way rows on the specified worksheet are added or deleted to accommodate the number of rows in a recordset returned by a query.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)
Usage
Dim xlCellInsertionMode1 As XlCellInsertionMode = XlCellInsertionMode.xlInsertDeleteCells
Syntax
Public Enum XlCellInsertionMode
public enum XlCellInsertionMode
public enum class XlCellInsertionMode
public enum XlCellInsertionMode
public enum XlCellInsertionMode
Members
Member name | Description |
---|---|
xlInsertDeleteCells | Partial rows are inserted or deleted to match the exact number of rows required for the new recordset. |
xlInsertEntireRows | Entire rows are inserted, if necessary, to accommodate any overflow. No cells or rows are deleted from the worksheet. |
xlOverwriteCells | No new cells or rows are added to the worksheet. Data in surrounding cells is overwritten to accommodate any overflow. |
Platforms
Development Platforms
Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000