AutoSize Property

Microsoft Excel Visual Basic

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

Example

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

Worksheets(1).Shapes(1).TextFrame.AutoSize = True