Inserts a cell or a range of cells into the worksheet and shifts other cells down to make space.

[Visual Basic]
Sub Insert()
[C#]
void Insert();
[C++]
void Insert();
[JScript]
function Insert();

Example

This example inserts range B2:F2 into sheet one and shifts other cells down.

[C#]
 book.Worksheets[1].Range["B2:F2"].Insert(); 

[Visual Basic]
 book.Worksheets(1).Range("B2:F2").Insert()

[C++]
 book->Worksheets->Item[1]->Range->Item[S"B2:F2"]->Insert(); 

See Also

IRange Interface | NativeExcel Namespace | IRange.Insert Overload List | Delete Method

---