Returns or sets the way rows on the specified worksheet are added or deleted to accommodate the number of rows in a recordset returned by a query. Read/write Long.
Can be one of the following xlCellInsertionMode constants.
| Constant | Description |
|---|---|
| xlOverwriteCells | No new cells or rows are added to the worksheet. Data in surrounding cells is overwritten to accommodate any overflow. |
| 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. |