Can't get the "Remove Duplicates" to work in a macro

[anwaee2]

This is what I'm trying to do:

First: unprotect a worksheet "Owner Information"
Then: copy C5:K69 from that worksheet
Then: protect worksheet "Owner Information"
Then: change to worksheet "Address Book"
Then: unprotect worksheet "Address Book"
Then: select A4:I75
Then: clear all
Then: select cell A4
Then: paste the C5:K69 from worksheet "Owner Information" that I have already copied
Then: swap columns A and B
Then: format columns to auto-fit
Then: remove duplicates from rows 6-73 using data from columns A and B (Last name, First name)
Then: sort rows 6-73 using data from columns A and B
Then: put border around each cell of remaining rows plus rows 4 and 5
Then: set protection to lock
Then: protect work sheet "Address Book"
Then: save worksheet "Address Book"

This is the macro I made:

Please Login or Register  to view this content.

I would like to do the "Remove Duplicates" routine either before or after the sort with the same range of cells. Any help would be appreciated. I might mention that I am using Excell for Mac 2011 14.2.3 with the OS 10.8.1. I tried using the "fix" for this on your forum but could not get it to work.

[arlu1201]

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. If you need more information on how to use them, check my signature below this post.

[arlu1201]

Your code can be written like this- without the select statements

Please Login or Register  to view this content.

[anwaee2]

Thank you, this works but it checks across the entire row for duplicates and I only want the first two columns to determine if the whole row gets deleted.

Thanks again, that was a big help.

[arlu1201]

I have not added anything to your code. I just removed the select statements and made it run a little faster. We still have to correct the remove duplicates part.