Option Explicit
Sub AdvancedFilter()
Dim RangeSource As Range
Dim RangeCible As Range
Set RangeSource = Range(Range('A1'), Range('A65536').End(xlUp))
Set RangeCible = Range('B1')
RangeSource.AdvancedFilter Action:=xlFilterCopy, CopyToRange:=RangeCible, Unique:=True
End Sub