VBA to Ahk remove duplicates

[blue83]

Hi,

Does anyone know how to translate this code to ahk?

ActiveSheet.Range("$A$1:$G$13").RemoveDuplicates Columns:=Array(1, 7), Header _
:=xlYes

[IMEime]

Code: Select all

xl.ActiveSheet.Range("$A$1:$G$13").RemoveDuplicates(1, True)

[TheDewd]

Code: Select all

#SingleInstance, Force

xlApp := ComObjActive("Excel.Application")
xlApp.ActiveSheet.Range("A1:G13").RemoveDuplicates(1, 1) ; Columns = 1, xlYes = 1

[Datapoint]

Code: Select all

    ActiveSheet.Range("$A$1:$G$13").RemoveDuplicates Columns:=Array(1, 7), Header _
        :=xlYes

Code: Select all

VT_VARIANT := 0xC
xlYes := 1
numberOfColumns := 2
Columns := ComObjArray(VT_VARIANT, numberOfColumns)
Columns[0] := 1
Columns[1] := 7
xlApp := ComObjActive("Excel.Application")
xlApp.ActiveSheet.Range("A1:G13").RemoveDuplicates(Columns, xlYes)

[blue83]

Wow, thank you on your help.

[IMEime]

@Datapoint
I was not clear about the Array part
Nice !! You made it clear