DeleteReplacement Method

Microsoft Excel Visual Basic

DeleteReplacement Method

       

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