Copy unique value form one sheet to another sheet

[nur2544]

Dear all, I have recorded a macro that is for copy unique value form one sheet to another sheet . Here is macro that I recorded , it works very well for my case but problem is that it is very slower .Would you please help me with faster macro ?

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

Untested in the absence of the workbook but maybe

Please Login or Register  to view this content.

Alternatively you could just copy column A to the Test Sheet and use the Remove Duplicates option in the Ribbon's Data area

[nur2544]

Hi Richard Buttrey , thanks for replay , yes your second option is best to Remove Duplicates form ribbon is fastest.would you please check the code for more shorter ? if not then i will work on it..

Please Login or Register  to view this content.

[AB33]

Please Login or Register  to view this content.

[nur2544]

Hi AB33 , thanks for reply. it works perfectly..