Help: Editing VBA code

Copper Contributor

Hi

 

I have a code that highlight duplicated words or numbers, it gives the first value a pink color, and the duplicate a green color.

 

AFAIK Words can't search for a specific highlight color. So what I want it to do so I can delete the duplicate values is to add underline to the duplicate instead of highlight.

 

 

This is the code:

 https://drive.google.com/file/d/1-DX2e4VN8SQVHOl-OBkASNuh_Jfb1TU2/view?pli=1

 

1 Reply

Use a wildcard Find/Replace, where

Find = (<*>)?\1

and'=

Replace = \1Note:

 

This assumes there is always a single character separating the repeated words and that they're of the same case.