Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-09-2023, 09:22 AM
Shelley Lou Shelley Lou is offline VBA help remove duplicates of blanks Windows 10 VBA help remove duplicates of blanks Office 2016
Expert
VBA help remove duplicates of blanks
 
Join Date: Dec 2020
Posts: 259
Shelley Lou is on a distinguished road
Default VBA help remove duplicates of blanks


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
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA help remove duplicates of blanks find/remove duplicates 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
VBA help remove duplicates of blanks Counting Blanks in 1 Column and Non-Blanks in Another 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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:56 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft