I define a Range object; set it to the used cells of a particular column; then apply a Filter. But although there is no error on this code, the filter does not appear to have been applied. (If I just filter the entire column raw, then the filter works). Any thoughts ? Thanks.
dim condensedRange as Range
Set condensedRange = WS.Range("A1", WS.Range("A1").End(xlDown).End(xlDown).End(xlUp))
condensedRange .AdvancedFilter Action:=xlFilterInPlace, Unique:=True