Returns or sets the text contents of an arbitrary cell.
object.TextArray( cellindex ) [= string ]
The TextArray property syntax has these parts:
| Part | Description |
|---|---|
| object | An object expression that evaluates to an object. |
| cellindex | Integer. A numeric expression specifying which cell to read or write. See Remarks. |
| string | A string expression containing the contents of an arbitrary cell. |
This property allows you to set or retrieve the contents of a cell without changing the Row and Col properties.
The cellindex argument determines which cell to use. It is calculated by multiplying the desired row by the Cols property and adding the desired column.