Notitie
Voor toegang tot deze pagina is autorisatie vereist. U kunt proberen u aan te melden of mappen te wijzigen.
Voor toegang tot deze pagina is autorisatie vereist. U kunt proberen om mappen te wijzigen.
Returns or sets a Variant value that indicates if text automatically shrinks to fit in the available column width.
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.
Rows(1).ShrinkToFit = True
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.