AutoCorrect.DeleteReplacement Method

  • Article
Excel Developer Reference

Deletes an entry from the array of AutoCorrect replacements.

Syntax

expression.DeleteReplacement(What)

expression   A variable that represents an AutoCorrect object.

Parameters

Name Required/Optional Data Type Description
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.

Return Value
Variant

Example

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

Visual Basic for Applications 
  With Application.AutoCorrect
    .DeleteReplacement "Temperature"
End With

See Also