Delete Duplicate Rows:create a macro

Hello,

Im having trouble. I know Ive seen a thread about this but the search feature on this site hasnt worked for me for a few days now so I had to start a new thread.

Im trying to create a macro that looks at coloumn B, then deletes all rows with the same value. The code I have from another site on Google doesn't work... at all really!

Thank you

Have you tried Chip Pearson's site?

http://www.cpearson.com/excel/duplicat.htm

Scroll to the bottom and he has link for deleting duplicates.

hth
---

Originally Posted by LB79

Hello,

Im having trouble. I know Ive seen a thread about this but the search feature on this site hasnt worked for me for a few days now so I had to start a new thread.

Im trying to create a macro that looks at coloumn B, then deletes all rows with the same value. The code I have from another site on Google doesn't work... at all really!

Thank you