![]() |
#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 | 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 |
![]() |
David Lee | Word | 6 | 08-16-2015 10:46 AM |
![]() |
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 |