|
|
#9
02-14-2022, 11:32 PM
|
||||
|
||||
Your second yellow line opens a For loop but you didn't include a Next aCell at the end.
Do a manual count of the words being returned by your code. If your code is returning an additional number of words that match the number of cells then it is likely you are also counting the end of cell markers as a word.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia 
|
| Tags |
| delete, identical |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Removing rows when mail merging
|
Richystab | Mail Merge | 3 | 12-07-2020 03:05 AM |
| Identical computers | MeCasa | Office | 0 | 09-23-2019 03:43 PM |
| Removing duplicate rows when identical value in a column | ballpoint | Excel | 1 | 01-05-2018 08:54 AM |
| how to delete every blank and non-numeric rows without removing the header | enuff | Excel | 3 | 08-24-2017 05:56 AM |
|
How to find an identical sentences?
|
Bill K | Word | 1 | 12-03-2015 12:16 AM |
Windows 10 
Office 2016
Threaded Mode