Returns or sets the text content of an arbitrary cell.
Syntax
object.TextArray(cellindex) [=string]
The TextArray property syntax has these parts:
Part | Description |
object | An object expression that evaluates to an object in the Applies To list. |
cellindex | Integer. A numeric expression that specifies which cell to read or write. See Remarks. |
string | A string expression containing the contents of an arbitrary cell. |
Remarks
This property makes it possible for 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 preferred row by the Cols property and adding the preferred column. The clearest and most convenient way to calculate cellindex is to define a function to do it, as shown in Example.