![]() |
#2
|
||||
|
||||
![]()
What's wrong with a simple Find/Replace loop, rather than a nested one? Far quicker:
Code:
Sub Demo() Application.ScreenUpdating = False Dim Rng As Range, arrWords, i As Long arrWords = Array("keyword1", "keyword2", "keyword3") Options.DefaultHighlightColorIndex = wdYellow Set Rng = Selection.Range With Rng .Paste With .Find .ClearFormatting .Replacement.ClearFormatting .Forward = True .Wrap = wdFindStop .Replacement.Text = "^&" .Replacement.Highlight = True For i = 0 To UBound(arrWords) .Text = arrWords(i) .Execute Replace:=wdReplaceAll Next End With End With 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 |