AddReplacement Method

Microsoft Excel Visual Basic

AddReplacement Method

       

Adds an entry to the array of AutoCorrect replacements.

expression.AddReplacement(What, Replacement)

expression   Required. An expression that returns an AutoCorrect object.

What   Required String. The text to be replaced. If this string already exists in the array of AutoCorrect replacements, the existing substitute text is replaced by the new text.

Replacement   Required String. The replacement text.

Example

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

With Application.AutoCorrect
    .AddReplacement "Temperature", "Temp."
End With