Microsoft Office Forums - View Single Post - [Solved] vba error (object required) for highlight vowels

macropod · 04-22-2012, 08:55 PM

To highlight the vowels in a document, try something like:

Code:

Sub HilightVowels()
Application.ScreenUpdating = False
With ActiveDocument.Range
  .HighlightColorIndex = wdYellow
  With .Find
  .ClearFormatting
  .Forward = True
  .Wrap = wdFindContinue
  .Format = True
  .MatchWildcards = True
  .Text = "[!AEIOUaeiou]"
  With .Replacement
    .ClearFormatting
    .Highlight = False
    .Text = "^&"
  End With
  .Execute Replace:=wdReplaceAll
End With
End With
Application.ScreenUpdating = True
End Sub