Range Object Properties 

The Range object has the properties:

 

Range Object Properties

Name

Type/Parameter

Description

LowerBound

Long

Lower index. Determines the starting row in the Table object.

UpperBound

Long

Upper index. Determines the ending row in the Table object.

LeftBound

Long

Left index. Determines the starting column in the Table object.

RightBound

Long

Right index. Determines the ending column in the Table object.

Data

Array of VARIANT

Gets/sets the data (all values) of the Range object. The data is returned as an array.

Value

Long RowIndex

Long ColumnIndex

Returns a single value in the Range object.