Columns Collection Methods: Remove 

Purpose

Removes an object from the Columns collection.

Syntax

The Remove method has the syntax:

Remove (Variant vaIndex)

Returns

type Boolean

Description

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 corresponding object is removed from the collection and marked as invalid. Any further attempt to work on this object leads to an ‘Invalid object’ exception.

String not convertible to an integer.

The parameter vaIndex is used to search and remove the object with the corresponding name from the collection.

Object

The parameter vaIndex is used to search and remove the objects which are the same as vaIndex.

If vaIndex is any type except Object, only one element is removed from the collection. If vaIndex is of type Object, all columns addressed by vaIndex are removed. This occurs if the object was inserted or added more often than once.