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.