View Single Post
 
Old 03-21-2023, 10:50 AM
Shelley Lou Shelley Lou is offline Windows 10 Office 2016
Expert
 
Join Date: Dec 2020
Posts: 259
Shelley Lou is on a distinguished road
Default VBA help remove duplicates of blanks updated

Hi Andrew, I've tidied up the code a little bit with regard to searching and deleting the less than and greater than symbols which is working great. I'm trying to work out how to include the superscript text within those symbols to be deleted at the same. It does appear however that the less than symbol followed by blue superscript text doesn't always have a closing greater than symbol - I'm probably over thinking it too much and should leave it alone but I was just curious how I would include searching for text within two Chr values.

Code:
.text = "[" & Chr(60) & Chr(62) & "]"
    .Replacement.text = ""
    .Execute Replace:=wdReplaceAll
Reply With Quote