How to Find & Highlight Duplicate Sentences in MS Word at once

How to Find & Highlight Duplicate Sentences in MS Word at once

Get eSolutions

4 года назад

120,838 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

Techie Suraj
Techie Suraj - 14.11.2023 16:21

How to find on Android

Ответить
Vane S
Vane S - 09.11.2023 23:41

not working

Ответить
Hawk 04
Hawk 04 - 02.11.2023 12:18

Thanks brother !! You saved my hours 👍

Ответить
Xaliq Cabbarov
Xaliq Cabbarov - 31.03.2023 17:12

Sub highlightdup()
Dim I, J As Long
Dim xRngFind, xRng As Range
Dim xStrFind, xStr As String
Options.DefaultHighlightColorIndex = wdYellow
Application.ScreenUpdating = False
With ActiveDocument
For I = 1 To .Paragraphs.Count - 1
Set xRngFind = .Paragraphs(I).Range
If xRngFind.HighlightColorIndex <> wdYellow Then
For J = I + 1 To .Paragraphs.Count
Set xRng = .Paragraphs(J).Range
If xRngFind.Text = xRng.Text Then
xRngFind.HighlightColorIndex = wdBrightGreen
xRng.HighlightColorIndex = wdYellow
End If
Next
End If
Next
End With
End Sub

Ответить
Agi H
Agi H - 17.03.2023 19:21

The link expired, would it be possible to update it please?

Ответить
Anglo Premier Translations
Anglo Premier Translations - 11.01.2023 02:29

Is there something that can identify near-duplicate sentences? In the documents I work in, the sentences often vary very slightly, but I'd still like to identify them.

Ответить
Ridwanur Rahman
Ridwanur Rahman - 16.12.2022 16:58

You Save My Time Thanks A Bunch

Ответить
Jes Gonzales
Jes Gonzales - 04.07.2022 10:15

Hi! Thanks so much for this! Don't know if anybody else is experiencing this though, but somehow the macros highlights the last paragraph of the document despite not having any duplicates...?

Ответить
Goodsons Mukosa Mpumba
Goodsons Mukosa Mpumba - 25.06.2022 08:58

Where am i getting the code from?

Ответить
José Zenteno
José Zenteno - 23.06.2022 21:48

The macro code link is expired again

Ответить
Mantan IT Channel
Mantan IT Channel - 09.04.2022 12:32

The Macro Code link is expired, can't be accessed

Ответить
Ferdous Khalifa
Ferdous Khalifa - 17.02.2022 18:53

Thanks a lot.

Ответить
shahzad alam
shahzad alam - 17.02.2022 10:05

after fixing how we can remove module function from a specific world document

Ответить
NAUGHTY ACTIONS
NAUGHTY ACTIONS - 14.02.2022 07:02

work only one time.

Ответить
Beulah Evangeline
Beulah Evangeline - 05.02.2022 17:34

thanks a lot

Ответить
Veteran2x
Veteran2x - 15.12.2021 22:35

Hi, do you have any idea where can I find infos about; How to highlight or find in a TEXT ALL the WORDS that starts or ends ONLY with a certain type of letter? thank you p/s It can be with word, excel, CSS, PHP or HTML

Ответить
NIVO onairam
NIVO onairam - 16.11.2021 01:42

You're a freakin genius!

Ответить
Ben Coffman
Ben Coffman - 11.10.2021 18:47

It only highlighted a small portion of the duplicated text.

Ответить
Payam Bakhshi
Payam Bakhshi - 09.10.2021 04:17

tested it, it works but doesn't find all the duplicates! disappointing :(

Ответить
Irfan How
Irfan How - 20.09.2021 20:00

In this video, we discuss finding and highlighting. But, I want to "find and delete words" that appear more than once, how do I do that? Please help me, thanks before..

Ответить
Aadesh Chauhan
Aadesh Chauhan - 04.09.2021 14:26

Thanks!

This worked

Ответить
Catarina F
Catarina F - 03.08.2021 17:36

Nice!! I just had to save the document as a Word Macro Document. Thanks!

Ответить
Mayur Borge
Mayur Borge - 26.07.2021 07:26

sir, how i find out same duplicate MCQ question in same question paper? please guide me for this.

Ответить
Wani Ashfaq
Wani Ashfaq - 23.07.2021 09:31

I do the same but it reflects as compile error....invalid outside procedure. Kindly help me to come out this problem

Ответить
Lemniscate Fortune Can Finally Chill
Lemniscate Fortune Can Finally Chill - 22.07.2021 11:35

The macro just hangs on ms office professional plus 2016??

Ответить
Hirbod Aflcok
Hirbod Aflcok - 17.07.2021 04:10

thank you so much you saved me hours
it works on words too :D

Ответить
Sasi
Sasi - 30.04.2021 22:43

Try blocking fn keys and then click on alt+f11

Ответить
QHSE HOME
QHSE HOME - 26.04.2021 05:03

👍Great

Ответить
HDPro wng
HDPro wng - 12.04.2021 11:34

Thank you for Find & Highlight Duplicate Paragraph or Sentences, it's Work!
Is it possible auto delete all Green Highlighted phrases?
or Find & Delete Duplicate Paragraph or Sentences?

Ответить
dave Wettlaufer
dave Wettlaufer - 08.04.2021 17:23

thanks for the video however I'm down to the module and I'm waiting for the code to come up, and I'm waiting. where does the code come from?

Ответить
Lasha Zhvania
Lasha Zhvania - 21.02.2021 20:37

not working on 2019. im waiting for 2 hours of precessing

Ответить
PPSC Zoology by FTF
PPSC Zoology by FTF - 11.01.2021 20:55

very nice and helpful

Ответить
Mobile Aze
Mobile Aze - 28.12.2020 18:42

thsnks its working

Ответить
Vượng Vũ
Vượng Vũ - 15.12.2020 13:29

totally useless

Ответить
sky Raining
sky Raining - 09.12.2020 09:33

does not work my word app closing instantly once I paste the code what's going on

Ответить
César Brasil
César Brasil - 07.11.2020 10:27

Not perfect, but quite helpful. Thanks a lot :)
PS: Took almost an hour on a 700 page document.

Ответить
Taino
Taino - 04.11.2020 23:38

Im doing Alt+F11 and Visual Basic does not show nor the modules.

Ответить
Shivansh Sharma
Shivansh Sharma - 26.08.2020 23:52

It's not opening it on ms word 2007 when I press alt+F11. Please help

Ответить
Lilit Muradyan
Lilit Muradyan - 23.07.2020 20:42

Where from i can copy macros code?

Ответить
Pankaj Singh
Pankaj Singh - 30.06.2020 08:55

Thanks you. Is there similar way to find and highlight duplicate words? it would be a great help if you could provide macro for it as well.

Ответить
-Frosty Fire-
-Frosty Fire- - 25.05.2020 19:02

thx

Ответить
NavaCHAITANYA Competitions
NavaCHAITANYA Competitions - 13.05.2020 06:19

Thankyou

Ответить
Norah AH
Norah AH - 15.04.2020 14:26

does not work well. it does not catch all the rep and bullet points

Ответить
CM
CM - 15.04.2020 10:02

FANTASTIC

Ответить
cheetu_
cheetu_ - 12.03.2020 18:44

Thank you!

Ответить
erich martin
erich martin - 07.03.2020 22:45

not working. even i cannot save . force me to save it as .docm

Ответить
Alexandra Sveum
Alexandra Sveum - 11.02.2020 00:09

This seems to work for some redundant text, but I still see duplicate text that isn't highlighted. What might prevent that from happening in the macro? Formatting? The dup language that it's not flagging is what triggered me to go find this (and grateful to see you sharing the macro), but I want to make sure nothing slips by when I share with colleagues. Thank you for the video!

Ответить
Semih Kıyma
Semih Kıyma - 21.01.2020 10:23

How I can do it in Macbook? We have no virtual basic for apps

Ответить
xiang zhen
xiang zhen - 10.09.2019 09:42

Thank you very much for sharing the code.But I still have a troube. If it is a language like Hindi or Japanese, it will not work. Can you please tell me how can I modify ? Thanks. The Language like "namaḥ saptānām samyaksambuddha koṭīnām śrāvaka saṃghānām".

Ответить