![]() |
#1
|
|||
|
|||
![]() I have today been given quite a few documents to house style and the first thing I need to do is to remove the coloured coding within the document. I have put together a small macro which deals with most of the tasks in one go, however, I can't work out how to remove duplicates of [●] to just one [●]. I then put these blank spaces into a text form field by using a find and replace ^c as I've never worked out how to add this step into a macro. If anyone can help with the duplication issue that would be great. I've added a very small reduced size document as the ones I'm working on are 100+ pages. coded test document.docx coding 1.png coding 2.png Code:
Sub DeleteCoding() Application.ScreenUpdating = False Dim Rng As Range With Selection.Range Set Rng = Selection.Range With Rng.Find .ClearFormatting .Replacement.ClearFormatting .Forward = True .Wrap = wdFindContinue .Format = False .MatchWildcards = True .text = "[\{]{1,}[!\}]@[\}]{1,}" 'find text within curly braces and replace with square bracket blank .Replacement.text = "[" & ChrW(9679) & "]" .Execute Replace:=wdReplaceAll .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 End With With Rng.Find .Format = False .Font.Superscript = True 'remove superscript wording .text = "" .Replacement.text = "" .Execute Replace:=wdReplaceAll End With Application.ScreenUpdating = True End With End Sub |
|
![]() |
||||
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 |