Matrix Object 

The Matrix object is the result of the SelectTo* methods provided in the Table object. The Matrix object has the following properties:

Matrix Object Properties

Name

Type

Description

RowCount

Long

Returns the number of rows in the matrix. Read-only.

ColumnCount

Long

Returns the number of columns in the matrix. Read-only.

IsRowVector

Boolean

Returns TRUE if the matrix contains only one row. Read-only.

IsColumnVector

Boolean

Returns TRUE if the matrix contains only one column. Read-only.

Data

Array of VARIANT

Gets/sets the data values in the Matrix object. The data is returned as an array.

Row

Long Index

Gets/sets the data values in one row of the matrix. The data is returned as an array.

Column

Long Index

Gets/sets the whole data of one column of the matrix. The data is returned as an array.

Value

Long RowIndex, Long ColumnIndex

Gets/sets the value of one matrix entry.