Share via

Text Property

  • Article

Text property as it applies to the PivotAggregate and PivotDetailCell objects.

Returns the specified value as a string based on the current NumberFormat property setting. Read-only String.

expression.Text

*expression   * Required. An expression that returns one of the above objects.

Text property as it applies to the Range object.

Returns the formatted value displayed in the specified cell. Returns Null if the range includes more than one cell and the cells do not all contain the same value. Use the IsNull function to determine whether the return value is Null. Read-only Variant.

expression.Text

*expression   * Required. An expression that returns a Range object.

Example

This example sets a variable for the formatted value of cell A1.

txt = Spreadsheet1.Range("a1").Text

Applies to | PivotAggregate Object | PivotDetailCell Object | Range Object

See Also | NumberFormat Property