Text Property
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