This documentation is archived and is not being maintained.

XlCellInsertionMode Enumeration

Office 2007
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.

Version Information
 Version Added:  Excel 2007

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