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

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

Example

This example inserts new column before column three.

[C#]
 book.Worksheets[1].UsedRange.Columns[3].Insert(); 

[Visual Basic]
 book.Worksheets(1).UsedRange.Columns(3).Insert()

[C++]
 book->Worksheets->Item[1]->UsedRange->Columns->Item[3]->Insert(); 

See Also

IRangeColumn Interface | NativeExcel Namespace | Delete Method

---