highlight duplicate rows

You could use Conditional Formatting to do this.

https://support.office.com/en-US/art...C-65D913033D18



Regards, TMS

When I look at the values for the following possible arguments for the End method with MsgBox(xlToLeft), MsgBox(xlToRight), ..., I get:
xlToLeft = -4159
xlToRight = -4161
xlUp = -4162
xlDown = -4121

...however, when I use 3 for an argument of the End method: End(3), as ikboy used above, I get the same results if I had used: End(xlUp).

Please explain.

@joe31623:

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

TMS,

Ok, Thanks for bringing that to my attention. Please feel free to delete this post and my last post.

I would suggest this is a new question and warrants a new thread. It's also going to be worth your while posting a sample workbook with some typical data.


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.