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
S
Expand Minimize

ShrinkToFit Property [Excel 2003 VBA Language Reference]

Office 2003

True if text automatically shrinks to fit in the available column width. Read/write Boolean.

expression.ShrinkToFit

expression Required. An expression that returns a Style object.

True if text automatically shrinks to fit in the available column width. Returns Null if this property isn't set to the same value for all cells in the specified range. Read/write Variant.

expression.ShrinkToFit

expression Required. An expression that returns one of the above objects.

Example

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

Rows(1).ShrinkToFit = True
		




Show:
© 2015 Microsoft