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.ShrinkToFit Property

Office 2007
Returns or sets a Variant value that indicates.

Syntax

expression.ShrinkToFit

expression   A variable that represents a Range object.

Remarks

This property returns True if text automatically shrinks to fit in the available column width, or Null if this property isn’t set to the same value for all cells in the specified range.

Example

This example causes text in row one to automatically shrink to fit in the available column width.

Visual Basic for Applications
Rows(1).ShrinkToFit = True



Community Additions

ADD
Show:
© 2015 Microsoft