XlCellInsertionMode enumeration (Excel)
Specifies the way that rows on the specified worksheet are added or deleted to accommodate the number of rows in a recordset returned by a query.
| Name | Value | Description |
|---|---|---|
| xlInsertDeleteCells | 1 | Partial rows are inserted or deleted to match the exact number of rows required for the new recordset. |
| xlInsertEntireRows | 2 | Entire rows are inserted, if necessary, to accommodate any overflow. No cells or rows are deleted from the worksheet. |
| xlOverwriteCells | 0 | No new cells or rows are added to the worksheet. Data in surrounding cells is overwritten to accommodate any overflow. |
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.