WrapText Property

Applies To

Range object, Style object.

Description

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 for the Range object, read/write Boolean for the Style object.

Remarks

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

Example

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