Problem using RemoveDuplicates

Hi,

I have a simple test worksheet and code. I am trying to delete any rows which are duplicates. I found this cool function called "RemoveDuplicates".

Here is microsoft link which explains how to use it.......


anyway, i am trying to use it but for some reason .....nothing happens......no duplicate rows are removed...........any ideas?

Below is my code an i am also enclosing file.
Note: For file just refer to sheet1............the last 4 rows of this sheet1 are duplicates and should be removed but they are not.


code is simple: see below

Please Login or Register  to view this content.

forgot to include link

HTML Code: 

hi,to should change exmple code $a$1:$o$9 to your local custom range , 4 rows meaning a1:o4 ?

This works on activesheet

Sub Macro1()
'

Please Login or Register  to view this content.

hi all,

if you look at the link it indicates i should not have to specify the columns IF i plan on using all the columns.....which is what i plan on doing and to be honest the number of cols will change so having to specify Array(1,2,3,....,x) each time would not be possible..........would it?

i am just lost ........can someone review the link as well.......am i reading it wrong.

just to be clear.......so as not to offend anyone.........what i ment by review the link was the "microsoft" link i provided.......in this link it gives an example (which is what i use) where it does not specify "Array(1,2,...,x)".....and this is the type of example i used..........

You do not have to specify all the columns, unless you want multiple conditions. For e.g. on the attached, you could have used one column 1 or 2. You get the same result.

But i want ALL the columns. And in the link from microsoft it says (and gives an example) that if you want all the cols you dont need to specify all of them........as i have done in my code.........but it does not work. i dont get an error or anything it just does nothing. which i was hoping ment that i was doing something wrong that was simple

When I run my code, it did delete the three rows with red and left one(You had 4 rows at the bottom, now have one)

AB33, can you post the code you used? i must be doing something simple that is wrong

Post #4 work with the attached sheet

AB33, in post #4 you specified the columns .......... is this how you got it to work? my code leaves off the columns and according to the microsoft documentation it is supposed to work but does not

But how does then code know which column you wish to delete?

If you look at Excel's remove duplicates functions and if you do not select any column, you will get nothing, so this proves you need to select the column.

AB33, so microsofts documentation is wrong......big surprise there..........

Below is microsoft's documentation:

"The following code sample removes duplicates with all columns from a range.

Visual Basic for Applications
ActiveSheet.Range("A1:C100").RemoveDuplicates "

norie, if you know how to do this please let me know.........i would greatly appreciate it.........any idea when you will be able to send out?

thanks again to all if i have not already said this...........

norie,

i continued searching on the net............i found a forum where you had responded on this very issue.......below is the code you presented in that forum.......

Please Login or Register  to view this content.

IT WORKED!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!


Things to note: The array starts out at 0 not 1. Since i have 15 columns i have the for-loop go from 0 to 14.


thanks.......this does seem to work............i will continue validating this ..........

norie,

i continued searching on the net............i found a forum where you had responded on this very issue.......below is the code you presented in that forum.......

Please Login or Register  to view this content.

IT WORKED!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!


Things to note: The array starts out at 0 not 1. Since i have 15 columns i have the for-loop go from 0 to 14.


thanks.......this does seem to work............i will continue validating this ..........

thanks norie........thanks to all who helped!!!!!!!!!! love this site........keep learning a lot!!!!!!!!!!!