How find and replace specific colour highlights?

G

Guest

How do I do a macro that finds all highlights in a praticular colour in a
document and replaces them with highlights of a different colur, or with no
highlight at all?
 
H

Helmut Weber

Hi, just one of some ways:
Sub Test453()
Dim oRng As Range
Set oRng = ActiveDocument.Range
ResetSearch
With oRng.Find
.Text = ""
.Highlight = True
While .Execute
If oRng.HighlightColorIndex = wdYellow Then
oRng.HighlightColorIndex = wdAuto
End If
oRng.Start = oRng.End
oRng.End = ActiveDocument.Range.End
Wend
End With
ResetSearch
End Sub
'---
Private Sub ResetSearch()
With Selection.Find
.ClearFormatting
.Replacement.ClearFormatting
.Text = ""
.Replacement.Text = ""
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
.Execute
End With
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

word or phrase selection highlight colour 1
whole document highlights 1
Finding Highlight 1
Replace shading with highlights 1
Excel JUMP FROM SEARCH BAR TO RESULT 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Highlighting in Word 2
How do I change highlight colour in Find and Replace 7

Top