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. |