XlCellInsertionMode XlCellInsertionMode XlCellInsertionMode Enum

Definition

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.

public enum class XlCellInsertionMode
public enum XlCellInsertionMode
Public Enum XlCellInsertionMode
Inheritance
XlCellInsertionModeXlCellInsertionModeXlCellInsertionMode

Fields

xlInsertDeleteCells xlInsertDeleteCells xlInsertDeleteCells 1

Partial rows are inserted or deleted to match the exact number of rows required for the new recordset.

xlInsertEntireRows xlInsertEntireRows xlInsertEntireRows 2

Entire rows are inserted, if necessary, to accommodate any overflow. No cells or rows are deleted from the worksheet.

xlOverwriteCells xlOverwriteCells xlOverwriteCells 0

No new cells or rows are added to the worksheet. Data in surrounding cells is overwritten to accommodate any overflow.

Applies to