DeleteReplacement Method [Excel 2003 VBA Language Reference]

  • Article

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

Applies to | AutoCorrect Object

See Also | AddReplacement Method