Range.Text (Excel)

Returns the formatted text for the specified string. Read-only String.

The Text property is most often used for a range of one cell. If the range includes more than one cell, the Text property returns Null, except when all the cells in the range have identical contents and formats. If the contents of the cell is wider than the width available for display, the Text property will modify the displayed value.

Dim strText As String
strText = ActiveCell.Text