This documentation is archived and is not being maintained.

WrapText Property [Excel 2003 VBA Language Reference]

Office 2003

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.

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

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
				




Show: