Allow removeduplicates to be used in VBA
In windows, remove duplicates function can be used in VBA and is very effective. Currently, Mac doesn't support this function in VBA. Please add this to be used on Mac as well. Thank you.
Good news. In version 16.x, the RemoveDuplicates command works in VBA.
Here’s an example of the code:
ActiveSheet.Range(“$a$1”).CurrentRegion.RemoveDuplicates Columns:=Array(1, 2), Header:=xlGuess
Steve K [MS Excel]
I came across this website which assists in removing duplicates without pop-up dialogues.
In Mac there is a Remove Duplicates popup that halts the completion of this code - how do we get rid of it??