Inserts a string preceding the specified Characters.

[Visual Basic]
Sub Insert( _ 
   ByVal Value As String _ 
)
[C#]
void Insert(
   string Value
);
[C++]
void Insert(
   String* Value
);
[JScript]
function Insert(
   String Value
);

Parameters

Value

The string to insert

Example

This example appends text at the end of B10 cell

[C#]
ICharacters c = book.Worksheets[1].Range["B10"].Characters;
c[c.Count + 1, 0].Insert("text"); 

[Visual Basic]
Dim c As ICharacters = book.Worksheets(1).Range("B10").Characters
c(c.Count + 1, 0).Insert("text") 

[C++]
ICharacters* c = book->Worksheets->Item[1]->Range->Item[S"B10"]->Characters;
c->Item[c->Count + 1, 0]->Insert(S"text");

See Also

ICharacters Interface | NativeExcel Namespace

---