delete duplicates

[Burt_100]

Hi,
Does anyone know why his is not finding and deleting the duplicates in sheet "Follow-Up" for me? I had it working but I jjust cant see what I have done to stop it?

Please Login or Register  to view this content.

Thanks
Johnny

[tehneXus]

Hi,

the macro is checking only A1 to A100

use:

Please Login or Register  to view this content.

works fine for me after that change, if you have more than 10000 rows it will be painfully slow though.

Regards

[Burt_100]

Hi,
I replaced the code: iListCount = Sheets("Follow-Up").Range("A1:A100").Rows.Count with the code that you gave me but when I run the macro it only deletes the A column and deletes one to many??? Im totally puzzled now??

[tehneXus]

how about this: http://msdn.microsoft.com/en-us/libr...ice.14%29.aspx

Regards

[arlu1201]

Burt,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.