Advanced filter to output uniques as values not formulas

[dchubbock]

I'm sure this is simple but i have a rather basic grasp of vba... still learning..

I have this code which works fine, however if the column contains formulas then it outputs the formulas. I only want the unique values:

Sheets("Raw Data").Range("B2:B100000").AdvancedFilter Action:=xlFilterCopy, _
CopyToRange:=Sheets("Config.").Range("B34"), Unique:=True

I have tried inserting the snippet PasteSpecial Paste:=xlPasteValues but to no avail.

Help much appreciated!

[walruseggman]

Because it is a filter, it does by nature not change anything in the filtered cells. Try something like this after you copy/filter:

Please Login or Register  to view this content.