You can't delete duplicate columns via using RemoveDuplicates method! You can delete duplicate rows.
Please, see:
Range.RemoveDuplicates Method (Excel)[
^]
So, to be able to get only unique rows, copy data from
D3:Fxx
range and paste it below data placed in
A1:Cxx
. Then you'll be able to run this code:
Sheets(2).Range("A3:C" & lastRow).RemoveDuplicates Columns:=Array(1, 2, 3), Header:=xlYes