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!