try as I might, it seems impossible to make Excel FULLY produce a unique filter product. If I do this :
For q = 1 To livecolumns
WS.Columns(1).AdvancedFilter Action:=xlFilterInPlace, Unique:=True
this takes columns in the first sheet (Sheet5) and copies them one at a time to sheet WS. WS then applies the filter, and copies the visible cells back to the already-cleared column in Sheet5. WS is then cleared, ready for the next incoming column of data.
But if a set of values has two identical values contiguous - ie in one cell below the other - then the filter does not get rid of one of them - although it works on the rest of the column's values, and does produce a list of uniques. Nothing I have tried has been able to work around this. Any ideas greatly appreciated
(PS If you are an expert wondering when I am going to close my other Excel Q, it is open because until I get this present problem solved, I cannot get to move the sheet up to Excel 2013.)