![]() |
#3
|
|||
|
|||
![]()
Works!
What would the VB code be if I wanted to run each find/replace separately but in the same macro? I tried this but it fails: Sub Macro1() Dim vFindText As Variant Dim vReplaceText As Variant Dim oRng As Range Dim i As Long vFindText = Array("%") vReplaceText = Array(" PERCENT") For i = 0 To UBound(vFindText) Set oRng = ActiveDocument.Range With oRng.Find .ClearFormatting .Replacement.ClearFormatting Do While .Execute(findText:=vFindText(i), _ MatchWholeWord:=True, _ Forward:=True, _ Wrap:=wdFindStop) = True oRng.Text = vReplaceText(i) oRng.Collapse wdCollapseEnd Loop End With Next lbl_Exit: Set oRng = Nothing Exit Sub ' Dim vFindText As Variant Dim vReplaceText As Variant Dim oRng As Range Dim i As Long vFindText = Array("/") vReplaceText = Array("' ") For i = 0 To UBound(vFindText) Set oRng = ActiveDocument.Range With oRng.Find .ClearFormatting .Replacement.ClearFormatting Do While .Execute(findText:=vFindText(i), _ MatchWholeWord:=True, _ Forward:=True, _ Wrap:=wdFindStop) = True oRng.Text = vReplaceText(i) oRng.Collapse wdCollapseEnd Loop End With Next lbl_Exit: Set oRng = Nothing Exit Sub |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
alex100 | Word VBA | 5 | 07-08-2020 04:14 AM |
![]() |
Surge | Word | 6 | 03-10-2020 12:42 AM |
![]() |
kvnrao | Word VBA | 7 | 11-02-2018 06:28 PM |
![]() |
mauuuuu5 | Word | 1 | 08-23-2015 09:20 PM |
![]() |
kjxavier | Word | 1 | 01-02-2015 12:15 AM |