Rows Collection Method: Remove 

Purpose

Removes a Row from the Rows collection.

Description

The parameter vaWhat describes the element to be removed. Legal variant types for vaWhat are VT_DISPATCH or any data type that may be converted into an integer value. If vaWhat has type VT_DISPATCH, the corresponding object is searched in the collection and removed. Otherwise vaWhat is converted to an index and the corresponding row is removed.

When removing a row from the rows collection, the Row object becomes invalid. Any further attempt to work on the object returns an invalid object exception.