Ranges Collection Methods 

The Ranges collection object has the following methods: Ranges Collection Method: Add

 

Ranges Collection Methods

Name

Parameter

Description

Remove

Long lWhat

Removes a Range object from the collection.

RemoveAll

 

Removes all Range objects from the collection.

Insert

Long lWhichItem

VARIANT vaWhat

Inserts a new Range object at a given position to the collection.

Add

VARIANT vaWhat,

Long LowerBound,

Long UpperBound,

Long LeftBound,

Long RightBound

Adds a new Range object to the collection.

All Parameters are optional.