Hi All,

I made a unique filtering, it works:

Range("C2:C367").AdvancedFilter Action:=xlFilterInPlace, Unique:=True

How can I define a range consisting of the unique visible cells?

Thanks,
Stefi