![]() |
|
#6
|
||||
|
||||
|
Since you can't us a BackgroundPatternColor property as a Find parameter, you'll need to revert to a nested loop. Try:
Code:
Sub Demo()
Application.ScreenUpdating = False
Dim Rng As Range, arrWords, i As Long, RGB As Long
arrWords = Array("keyword1 & keyword2", "keyword1", "keyword2", "keyword3")
Set Rng = Selection.Range
Rng.Paste
For i = 0 To UBound(arrWords)
Select Case i
Case 0: RGB = wdColorGray05
Case 1: RGB = wdColorPaleBlue
Case 2: RGB = wdColorLightOrange
Case 3: RGB = wdColorPink
End Select
With Selection
With .Find
.ClearFormatting
.Text = arrWords(i)
.Replacement.Text = ""
.Format = False
.Forward = True
.Wrap = wdFindStop
End With
Do While .Find.Execute
If .InRange(Rng) = False Then Exit Do
If .Shading.BackgroundPatternColor = wdColorAutomatic Then .Shading.BackgroundPatternColor = RGB
.Collapse wdCollapseEnd
Loop
End With
Rng.Select
Next
Application.ScreenUpdating = True
End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| I am trying to delete text of any format between two bold, recurring keywords or symbols | qubie | Word VBA | 8 | 03-04-2020 03:20 PM |
how do I make pasted text the same size as the text it's being pasted into?
|
David Lee | Word | 6 | 08-16-2015 10:46 AM |
Help with finding multiple keywords in a single document then highlight
|
navyguy | Word | 2 | 01-03-2014 12:48 PM |
| Trying to highlight pasted text in a macro | goldengate | Word VBA | 0 | 09-14-2010 09:41 PM |
| find - reading highlight - highlight all / highlight doesn't stick when saved | bobk544 | Word | 3 | 04-15-2009 03:31 PM |