Hello:
Please refer to attached file.
I have numbers in column A.
I need VB Code to find the duplicates, highlight and then give a choice to delete the row (Y/N).
Let me know if you have any questions.
Thanks.
Riz
Hello:
Please refer to attached file.
I have numbers in column A.
I need VB Code to find the duplicates, highlight and then give a choice to delete the row (Y/N).
Let me know if you have any questions.
Thanks.
Riz
Hi Riz,
Try this:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Hello xladept:
Works great except I would like to make small change.
It needs to first find all duplicates and highlight all the duplicates.
Then give a choice to delete all duplicate.
Please let me know if you have any questions.
Thanks.
Riz
Hi Riz,
Try this:
Please Login or Register to view this content.
Hi xladept:
This works great...
Thanks a lot.
Riz
You're welcome and thanks for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks