Feedback by UserVoice

How can we improve Excel for Mac?

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.

20 votes
Sign in
(thinking…)
Password icon
Signed in as (Sign out)

We’ll send you updates on this idea

Alex Liberatore shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
completed  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded  · 

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]

2 comments

Sign in
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base