Macro to Find unique values in three columns

Originally Posted by RahulRaman

Hi,
I am a newbie to excel macro. I need to write a macro for finding unique values between columns A,B,C. That means I need maco to write values which are unique in these three columns to column D.

Can any one help me in this...

Thanks a million.

Here is wer I've reached....

Please Login or Register  to view this content.

cn anybody tel me is it right or wrong...?

If it works it is right, if it doesn't it is wrong.
What is definitly wrong is you need to wrap your code in Code Tags.
Edit your post, click 'Go Advanced', select your code, and then click the [#] button above the edit area.

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

Originally Posted by Phil_V

If it works it is right, if it doesn't it is wrong.
What is definitly wrong is you need to wrap your code in Code Tags.
Edit your post, click 'Go Advanced', select your code, and then click the [#] button above the edit area.

Thanks for the tags prompt.

Agreed if it works it's right - RahulRaman check your code

However, code can often work but be written to work more efficiently. I would automate AdvancedFilter -> Unique Values & copy to the required column..

Attach a workbook with example data for further help