have you try
Code: Select all
ActiveSheet.Range("A1:C100").RemoveDuplicates
Code: Select all
ActiveSheet.Range("A1:C100").RemoveDuplicates Columns:=Array(1,2), Header:=xlYes
Code: Select all
ActiveSheet.Range("A1:C100").RemoveDuplicates
Code: Select all
ActiveSheet.Range("A1:C100").RemoveDuplicates Columns:=Array(1,2), Header:=xlYes