Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

Range.WrapText Property

Office 2007
Returns or sets a Variant value that indicates if Microsoft Excel wraps the text in the object.



expression   A variable that represents a Range object.


This property returns True if text is wrapped in all cells within the specified range, False if text is not wrapped in all cells within the specified range, or Null if the specified range contains some cells that wrap text and other cells that don't.

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


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

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

Community Additions

© 2015 Microsoft