Export (0) Print
Expand All
Expand Minimize

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)

Dim xlCellInsertionMode1 As XlCellInsertionMode = XlCellInsertionMode.xlInsertDeleteCells

public enum XlCellInsertionMode
public enum XlCellInsertionMode
public enum XlCellInsertionMode

Member nameDescription
xlInsertDeleteCellsPartial rows are inserted or deleted to match the exact number of rows required for the new recordset.
xlInsertEntireRowsEntire rows are inserted, if necessary, to accommodate any overflow. No cells or rows are deleted from the worksheet.
xlOverwriteCellsNo new cells or rows are added to the worksheet. Data in surrounding cells is overwritten to accommodate any overflow.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

Community Additions

© 2014 Microsoft