Export (0) Print
Expand All
6 out of 11 rated this helpful - Rate this topic

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
				




Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.