Macro to set Flag on dup values

I wrote this macro:

Please Login or Register  to view this content.

But it dosn't seem to work the worksheet function isn't working. Can anyone help is there something else I need to do or may have done.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

why have you created yet another duplicate ???

http://www.excelforum.com/excel-work...-set-flag.html

This is the 3rd time you've posted the same question.

It seems you haven't bothered to read the Forum Rules or else you would know about code tags, duplicate posts etc.

I am locking your posts until you PM me or another moderator that you will comply with all the Forum Rules in future. There is generally at least one moderator online so excuses like "I couldn't find my original post" aren't necessary, ask one for help!