Home > VBAUsefulCodes
Remove duplicates from column(s)
Remove Duplicates
Remove duplicates from column(s)
' Single Column
ThisWorkbook.Sheets("EMAILLIST").Columns(1).RemoveDuplicates Columns:=Array(1)
' Multiple Columns
ThisWorkbook.Sheets("EMAILLIST").Range("A:C").RemoveDuplicates Columns:=Array(1, 2, 3)
Subscribe
More to Explore
Tags
VBA Outlook KPI Excel Alt+F11 Dashboards Macros Recording Graphs Automation Developer WaterFall Powerpoint Charts Pivot Tables Forecast Charts