raycini
06-13-2011, 08:35 AM
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
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