DeleteReplacement Method

Microsoft Excel Visual Basic

Deletes an entry from the array of AutoCorrect replacements.

expression.DeleteReplacement(What)

expression    Required. An expression that returns an AutoCorrect object.

What    Required String. The text to be replaced, as it appears in the row to be deleted from the array of AutoCorrect replacements. If this string doesn't exist in the array of AutoCorrect replacements, this method fails.

Example

This example removes the word "Temperature" from the array of AutoCorrect replacements.

With Application.AutoCorrect
    .DeleteReplacement "Temperature"
End With