Hi,
Does anyone know how to translate this code to ahk?
ActiveSheet.Range("$A$1:$G$13").RemoveDuplicates Columns:=Array(1, 7), Header _
:=xlYes
VBA to Ahk remove duplicates
Re: VBA to Ahk remove duplicates
Code: Select all
xl.ActiveSheet.Range("$A$1:$G$13").RemoveDuplicates(1, True)
Re: VBA to Ahk remove duplicates
Code: Select all
#SingleInstance, Force
xlApp := ComObjActive("Excel.Application")
xlApp.ActiveSheet.Range("A1:G13").RemoveDuplicates(1, 1) ; Columns = 1, xlYes = 1
Re: VBA to Ahk remove duplicates
blue83 wrote: ↑01 Feb 2019, 08:12Code: 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)
Re: VBA to Ahk remove duplicates
Wow, thank you on your help.
Re: VBA to Ahk remove duplicates
@Datapoint
I was not clear about the Array part
Nice !! You made it clear
I was not clear about the Array part
Nice !! You made it clear
Who is online
Users browsing this forum: CuriousDad, rc76 and 232 guests