WrapText Property

Microsoft Excel Visual Basic

True if Microsoft Excel wraps the text in the object. Read/write Boolean.

expression.WrapText

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

ShowWrapText property as it applies to the CellFormat and Range objects.

True if Microsoft Excel wraps the text in the object. Returns Null if the specified range contains some cells that wrap text and other cells that don’t. Read/write Variant.

expression.WrapText

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

Remarks

Microsoft Excel will change the row height of the range, if necessary, to accommodate the text in the range.

Example

ShowAs it applies to the Range object.

This example formats cell B2 on Sheet1 so that the text wraps within the cell.

Worksheets("Sheet1").Range("B2").Value = _
    "This text should wrap in a cell."
Worksheets("Sheet1").Range("B2").WrapText = True