Modifying Macro

Hi guys, I have this macro provided to me by royUK. I've modified this code abit in such a way that it will check for all duplicated values in Column B and display the word "Duplicated" in the corresponding Cloumn C.

Please Login or Register  to view this content.

But now i need to modify the code again so that it will delete duplicated values in Column B instead. I'm not sure how. Tried afew ways but didn't work out. Any help here would be greatly appreciated.

Thanks guys.

Hi,

Untested but try changing that inner line

Please Login or Register  to view this content.

HTH

I tried and it works. But everytime I ran the script, it will display error message which is: "Run-time error 1004 - Unable to get the FindNext property of the Range class"

So is there another way where i can edit this code to check from Column A all the way down to the last cell and delete all duplicates?