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