LinkBack URL
About LinkBacks
I have an array A1:F1500 is important to find if any of the rows are repeated, I attache a little example, I don't want use excel functions I want a vba code to do this task, I am using excel 2003. any executable file welcome. thanks.
HTML Code:
I have an array A1:F1500 is important to find if any of the rows are repeated, I attache a little example, I don't want use excel functions I want a vba code to do this task, I am using excel 2003. any executable file welcome. thanks.
HTML Code:
Hi
Here goes.
rylo
Please Login or Register to view this content.
Hello dimvelements13579,
Welcome to the Forum!
I am not sure what you want to do with the duplicates: move them to another sheet, delete them, etc. This macro will highlight any rows that are duplicated. It is not particularly useful sense there is no information as to which row was duplicated. This macro can be easily changed to do what you want. Let me know what you want to do with the duplicates and I will make the changes.
Add a new VBA Module to your workbook. Copy and paste this code into the new module.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Give this a try. Note it assumes nothing else of value is in columns G, H or I.
Please Login or Register to view this content.
Leith Ross & Mallycat thank you so much,
Hello dimvelements1357,
Is your problem solved?
[solved]...........
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks