Sub UniqueList_Thierry()
'superbe idée de _thierry, merci.
Dim RangeSource As Range
Dim RangeCible As Range
Set RangeSource = Range(Range('A4'), Range('A65536').End(xlUp))
Set RangeCible = Range('j4')
Range(Range('j3'), Range('j65536').End(xlUp)).Clear
RangeSource.AdvancedFilter Action:=xlFilterCopy, CopyToRange:=RangeCible, Unique:=True
Range(Range('J5'), Range('j65536').End(xlUp)).Sort Key1:=Range('J5')
End Sub