Sub SelectionToUniqueValuesInNewWB() 'To get unique values from one column into new workbook: Selection.Copy Workbooks.Add Range("A1").PasteSpecial xlPasteValues Range("A:A").RemoveDuplicates Columns:=1, Header:=xlNo End Sub
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter