View Single Post
 
Old 09-06-2015, 11:36 PM
cyraxote cyraxote is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Sep 2015
Location: Essex, MD
Posts: 24
cyraxote is on a distinguished road
Default

I did the test as you suggested, and that got stuck in the endless loop, as did your alternate version. I'm using Word 2007, if that makes a difference.

My macro worked apart from the form when SearchColor and ReplaceColor were dimensioned as String, not Long. That's the only big difference I can see between this and the last working version. So I changed them back to strings:

Code:
Private Sub DoColorChange(SearchColor As String, ReplaceColor As String)

Dim oDoc As Document
Dim oRng As Range

Set oDoc = ActiveDocument
Set oRng = oDoc.Range

With oRng.Find
    .Highlight = True
    Do While oRng.Find.Execute
        If oRng.HighlightColorIndex = SearchColor Then
           oRng.HighlightColorIndex = ReplaceColor
        End If
        oRng.Collapse 0
    Loop
End With

End Sub
Sub Macro50()
    DoColorChange wdYellow, wdPink
End Sub
And this too causes the endless loop.

I went all the way back to the first one I posted, and now it TOO has the endless loop.

This is puzzling.
Reply With Quote