Problem with RemoveDuplicates method

[Mayda89]

Hi everyone,

I have written a code to remove duplicates from a given range, and the problem is, my code works without any problem in my Mac computer (excel 2011), but when I try to run this code on Windows (excel 2010), the remove duplicates method just does not remove the duplicates!!!
The part of the code that doesn't work was:

Please Login or Register  to view this content.

Please note that there is no problem with the definition of the range.

I know that the removeduplicates method has the two optional parameters 'columns' & 'header', which I omitted at first. I have omitted them because the default options for these paramaters suit my needs. After multiple trials, I have noticed that when I omit the 'columns' parameter in Excel 2010 in Windows, the removeduplicates method does not do anything! It does not even give an error! So then, I tried to accomplish the task by simply inputting the columns and header parameters, like this:

Please Login or Register  to view this content.

Note that colnumber is a variable, which is defined as an integer, and it is the first column of the range.

When write a simple line of code like this in a new macro, the code works. However, when I run this code in the whole macro I wrote, I have an even more interesting problem, it runs smoothly the first time in the loop, than after that it keeps on generating the error "application defined or object defined error". The code as it is in the loop is below.

Please Login or Register  to view this content.

Note that the worksheet I am working on is not protected.

Please help me, I have been searching all over the internet for weeks, and I couldn't find anything to this annoying problem!

Gokalp

[Norie]

For that last code try this.

Please Login or Register  to view this content.

[Mayda89]

Hi Norie,
Thanks for the rapid response
Unortunately, your suggestion doesn't solve the problem

[Norie]

Oops, forgot to change something.

Which columns are you actually trying to remove duplicates from?

Is this any better?

Please Login or Register  to view this content.

[Mayda89]

Actually, I am indifferent, because if the values in the first column are the same, then the values in the second column will also be the same. Yet, for simplicity, I am telling Excel to remove the duplicates from the column referred to by the variable ColDrft.

[Norie]

Check the code I added.

[Mayda89]

Oh I got it!
So I got the meaning of the columns parameter all wrong! The columns parameter should actually refer to the position of the column in the defined range, not the column number of the columns of interest!

Dear Norie, I cannot thank you enough!!!!!!!
Thank you very very much!!!!!!


Take Care!
Gokalp