View Single Post
 
Old 09-02-2021, 11:50 AM
Cendrinne's Avatar
Cendrinne Cendrinne is offline Windows 10 Office 2019
Competent Performer
 
Join Date: Aug 2019
Location: Montreal Quebec Canada
Posts: 190
Cendrinne is on a distinguished road
Default Help with a script to find Duplicate data in the same row of a table or tables

Hello Pros,
I found a fantastic macro, here, to highlight duplicate data in each rows, but for the first two columns, or the only two columns.

I've tried, so much, to modify, it, either I get an error message, or doesn't do anything.

This is the link of the script:
HTML Code:
https://www.msofficeforums.com/word-vba/28692-using-vba-compare-highlight-words-word-tables.html
I don't really understand it as it is, but tried many things, even modified the cell numbers for the columns I wanted to compare, but I got an error message. It did it, but I don't know how to get rid of that error message .

I need is to Highlight any variable (letters, symbol or numbers) in the same row, of one Table or any tables.

Any insights, would be greatly be appreciated.

Cendrinne
Reply With Quote