Thread: [Solved] VBA help remove duplicates of blanks
View Single Post
 
Old 03-10-2023, 06:51 AM
Shelley Lou Shelley Lou is offline Windows 10 Office 2016
Competent Performer
  
Join Date: Dec 2020
Posts: 170
Shelley Lou is on a distinguished road
Default VBA help remove duplicates of blanks
Hi Andrew, thank you for replying - I added your extra bit of code and I think it has removed a few of the duplicates but many still remain - with regard to your query re separated by spaces, yes that would be great if those could be included also.

Code:
.text = "[\[" & ChrW(9679) & "\]]{4,}"
    .Execute Replace:=wdReplaceAll
Capture 1.JPG

Capture 2.JPG
Reply With Quote