highlight duplicate rows

Hi,

i am trying to find a coding to highlight duplicate rows within the same sheet.

Please Login or Register  to view this content.

the code above is found using macro recorder. i am wondering if anyone knows whether is there any coding that can replace "removeduplicates" with "highlightduplicates" or coding with similar meaning.

OR

Please Login or Register  to view this content.

my intention is to let cl become a row and compare it with the rest of the rows. However, "application-defined or object-defined error" has occured and "cl = sheet1.cells(i,1).resize(1,3) has been highlighted.

can anyone help me to correct my coding?

Thank you.