Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 03-21-2023, 10:50 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 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
 



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 01:40 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