![]() |
#5
|
||||
|
||||
![]()
Try this version
Code:
Sub DeleteCoding() Dim Rng As Range 'Application.ScreenUpdating = False Set Rng = Selection.Range With Rng.Find .ClearFormatting .Replacement.ClearFormatting .Forward = True .Wrap = wdFindContinue .Format = False .MatchWildcards = False .Text = "<" 'remove all instances of less than symbol .Replacement.Text = "" .Execute Replace:=wdReplaceAll .Text = ">" 'remove all instances of greater than sumbol .Replacement.Text = "" .Execute Replace:=wdReplaceAll .Format = False .Font.Superscript = True 'remove superscript wording .Text = "" .Replacement.Text = "" .Execute Replace:=wdReplaceAll .MatchWildcards = True .ClearFormatting .Text = "[\{]{1,}[!\}]@[\}]{1,}" 'find text within curly braces and replace with square bracket blank .Replacement.Text = "[" & ChrW(9679) & "]" .Execute Replace:=wdReplaceAll .MatchWildcards = False .Text = "]^w[" 'remove spaces between ][ .Replacement.Text = "][" .Execute Replace:=wdReplaceAll .MatchWildcards = True .Text = "[\[" & ChrW(9679) & "\]]{4,}" .Replacement.Text = "[" & ChrW(9679) & "]" .Execute Replace:=wdReplaceAll End With 'Application.ScreenUpdating = True End Sub
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
hephalumph | Word | 9 | 02-06-2022 07:23 PM |
look for VBA to remove Duplicates from Subfolders | nf24eg | Outlook | 0 | 08-12-2021 05:03 AM |
Macro to keep first instance and remove duplicates in certain column | zhead | Excel | 2 | 03-18-2015 10:16 AM |
![]() |
dogwood705 | Excel | 4 | 02-07-2015 08:45 AM |
Macro to remove duplicates in Refrences list | HowardC | Word VBA | 0 | 05-20-2010 09:57 AM |