The following should work and appears to do so with your sample
Sub Macro1() Dim vFindText As Variant Dim vReplaceText As Variant Dim oRng As Range Dim i As Integer Dim lAsk As Long vFindText = Array(ChrW(61616), ChrW(61617)) vReplaceText = Array(Chr(176), Chr(177)) For i = 0 To UBound(vFindText) Set oRng = ActiveDocument.Range With oRng.Find .Text = vFindText(i) Do While .Execute oRng.Select lAsk = MsgBox("Replace Symbol", vbYesNoCancel) If lAsk = 2 Then GoTo lbl_Exit If lAsk = 6 Then oRng.Text = vReplaceText(i) oRng.Font.Name = "Times New Roman" End If oRng.Collapse 0 Loop End With Next i lbl_Exit: Exit Sub End Sub Sub Macro2() Dim vFindText As Variant Dim vReplaceText As Variant Dim oRng As Range Dim i As Integer Dim lAsk As Long vFindText = Array(Chr(176), Chr(177)) vReplaceText = Array(ChrW(61616), ChrW(61617)) For i = 0 To UBound(vFindText) Set oRng = ActiveDocument.Range With oRng.Find .Text = vFindText(i) Do While .Execute oRng.Select lAsk = MsgBox("Replace Symbol", vbYesNoCancel) If lAsk = 2 Then GoTo lbl_Exit If lAsk = 6 Then oRng.Text = vReplaceText(i) oRng.Font.Name = "Symbol" End If oRng.Collapse 0 Loop End With Next i lbl_Exit: Exit Sub End Sub





Reply With Quote