VBA to remove duplicates

[kenadams378]

Hi,

How can i remove duplicate data using VBA.


For example i need it to remove any duplicate numbers from column A but remove all data from the range A:P

[dilipandey]

Hi Kendadams,


Would be helpful if you could share a sample workbook.. thanks.


Regards,
DILIPandey
<click on below * if this helps>

[AB33]

Ken,

With out looking at your data

Please Login or Register  to view this content.

[kenadams378]

Many Thanks

That works perfectly

[AB33]

Ken,
You are welcome!
Could you please now close (Mark) this thread as solved? Go to the top right-hand side of this page, choose "Thread Tools" from the menu, then select "solved" from the drop down menu.