TextFrame.AutoSize property (Excel)

True if the size of the specified object is changed automatically to fit text within its boundaries. Read/write Boolean.

Syntax

expression.AutoSize

expression A variable that represents a TextFrame object.

Example

This example adjusts the size of the text frame on shape one to fit its text.

Worksheets(1).Shapes(1).TextFrame.AutoSize = 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.