RemoveDuplicates in VBA not working properly
When dealing with multiple columns, i.e.
CODE: range.removeduplicates columns:=array(1,2)
A prompt showed up and ask user whether or not delete duplicate values
It causes problem because without confirming deletion, the code won't run correctly. and what make the whole thing worse is that the code finishes running before I had a chance to confirm the deletion.
Is there any update on this?
Having the same issue? Anyone find a resolution?
I have the same problem. Did you find a solution ?
Jerry Johnson commented
I just got excel for mac 2016 and my straight forward RemoveDuplicates code: Selection.RemoveDuplicates is not working. It was built in excel mac 2011 and worked just fine. Any status update on a fix or troubleshoot for this?