Macros update - change only highlighted terms throughout document

gmaxey · #1 02-11-2020, 08:09 AM

Code:

Sub ScratchMacro()
  'A basic Word macro coded by Greg Maxey
Dim oRng As Range
  Set oRng = Selection.Range
  With oRng.Find
    .ClearFormatting
    .Replacement.ClearFormatting
    .Text = "USD"
    .Replacement.Text = "US Dollars"
    .Highlight = True
    .Execute Replace:=wdReplaceAll
  End With
lbl_Exit:
  Exit Sub
End Sub

irinarox · #2 02-11-2020, 08:20 AM

Thanks Greg! There is only one issue here - I was looking for a way in which only the yellow highlighted ones are changed by this Macro - for example if I have an USD text which is highlighted in green in the same document - then it should remain unchanged.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA code to compile one document based on multiple search terms	Hoxton118	Word VBA	4	04-04-2021 06:02 AM
Backspace Highlighted Field in Protected Document	ACDJFS	Word	12	03-17-2020 03:37 PM
Best Practice for Indexing Multiple Word Terms and Sub-Terms	jhy001	Word	4	11-06-2017 02:08 PM
Code to update macros automatically in startup folder	dwirony	Word VBA	4	01-12-2017 08:23 AM
Can you make templates dynamically update macros/etc. from Normal.DOT?	New Daddy	Word	2	11-18-2013 09:07 AM