Rows Collection Methods: Insert 

Purpose

Inserts an object into the Rows collection

Syntax

The Insert method has the syntax:

Remove(Variant vaIndex, Variant vaWhat)

Returns

type Object

Description

Inserts an object into the collection. Legal types for the parameter vaIndex are:

Type

Description

Any type convertible to an integer.

The parameter vaIndex is converted to an integer and used as index in the collection. The object is inserted prior to the object found.

Object

The parameter vaindex is used to search the objects. Prior to this object the new object is inserted.

Legal types for the parameter vaWhat are the same as for the Add Method.

If vaIndex is of type Object, the entire collection is searched for the object. This may be very ineffective. Since a Row collection may hold the same object only once, it is better to use the Row object’s Index property.

Rows.Insert(Row.Index,)