WrapText Property

Applies To

Range Object, Style Object.

Description

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

Remarks

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

Example

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

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