AutoCorrect Property
Collapse the table of content
Expand the table of content

Application.AutoCorrect Property (Excel)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Returns an AutoCorrect object that represents the Microsoft Excel AutoCorrect attributes. Read-only.

expression .AutoCorrect

expression A variable that represents an Application object.

This example substitutes the word "Temp." for the word "Temperature" in the array of AutoCorrect replacements.

With Application.AutoCorrect 
 .AddReplacement "Temperature", "Temp." 
End With
© 2016 Microsoft