Don't use a macro its overkill for something simple, you can use conditional
formatting you can select the whole area to give it a name like range1 select
conditional formattingformula is, paste this in =COUNTIF(range1,A1)1 and
select your colour, now all duplicates will e highlighted!

Regards,
The Code Cage Team
www.thecodecage.com/forumz

"Anitacr" wrote:

I need to verify in a column which cells are duplicated.
I don´t know how to do it in VBA, or the correct Excel´s function.
Example:

Column X

9675
9868
9868
9619
9868
9619
9619
9619
9619
9619

I want to identify the cells with same contents and mark them, with a
conditional format.

Anybody can help me?

Please!

--
Anitacr