Call Method Remove Duplicates from VBA

[raycini]

Hi,

I am trying to call method removeDuplicates from VBA but it is not working. Here is the code

ActiveSheet.Range("AA2:AA15").removeDuplicates

I have search on Excel help but the code shown in the example is as pasted here.

Do you have an idea of what is wrong.

Thanks

ray

[Kenneth Hobs]

Welcome to the forum!

You will need the first parameter:
ActiveSheet.Range("AA2:AA15").removeDuplicates Columns:=Array(1)

[raycini]

Thanks Kenneth :)

Ray

[محتاج2010]

You are very professional. Thank you very much













Welcome to the forum!

You will need the first parameter:
ActiveSheet.Range("AA2:AA15").removeDuplicates Columns:=Array(1)