There is another function called .Distinct you could look at.
Here is an example:
i just copied it from another post on here so you could search for more details. I believe it will return a datatable with only unique rows.
EDIT: I recommend using Datatable manipulation, but there’s also a good way to do it in the Excel Scope using key combinations.
So you can use Select Range to select entire table, then if you press Alt, A, M, a few tabs, space to deselect columns, then enter, it will use the Remove Duplicates button.
"[k(alt)]am[k(tab)][k(tab)][k(tab)][k(tab)][k(down)] [k(down)] [k(enter)]"
Like I said though, datatable manipulation is internal similar to VB and recommended.