Can someone assist me with highlighting rows that are duplicated on a spread sheet? It will validate one column and if the contents are dulplicated then the entire row A - E should be highlighted. I searched for a solution for this but most people are suggesting conditional formatting, i dont want to use that based on how I want the program to function.
Hi kmakjop,
After you've identified the duplicate, using r for the duplicate's row - you could write 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
Thanks xladept but I am trying to get assistance with finding the duplicates, not just how to highlight them.
Originally Posted by xladept
Hi kmakjop,
After you've identified the duplicate, using r for the duplicate's row - you could write this:
Please Login or Register to view this content.
do you have a sample workbook to show us?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Ok after searching and experimenting i came up with a code to highlight duplicated rows on a sheet. However it’s only highlighting the first row of the duplication. How can i get it to highlight all the occurrences in the column it’s checking through? I would prefer it highlighting all the occurrences or at least the last occurrences.
Below is the code i came up with, kindly assist with the modification if you can please:
Please Login or Register to view this content.
Just amending that code,
If all your columns and rows are correct this should work.
Please Login or Register to view this content.
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks