Remove Duplicates from range of cells in excel vba

by

You need to tell the Range.RemoveDuplicates method what column to use. Additionally, since you have expressed that you have a header row, you should tell the .RemoveDuplicates method that.

Sub dedupe_abcd()
    Dim icol As Long

    With Sheets("Sheet1")   '<-set this worksheet reference properly!
        icol = Application.Match("abcd", .Rows(1), 0)
        With .Cells(1, 1).CurrentRegion
            .RemoveDuplicates Columns:=icol, Header:=xlYes
        End With
    End With
End Sub

Your original code seemed to want to remove duplicates from a single column while ignoring surrounding data. That scenario is atypical and I’ve included the surrounding data so that the .RemoveDuplicates process does not scramble your data. Post back a comment if you truly wanted to isolate the RemoveDuplicates process to a single column.

More Related Contents:

  1. TextJoin UDF For Excel 2013
  2. to make this code simpler
  3. VBA code takes long time to execute in excel
  4. Excel VBA deleting rows in a for loop misses rows
  5. What is the lifetime of a global variable in excel vba?
  6. “Unable to get the VLookup property of the WorksheetFunction Class” error [duplicate]
  7. Download attachment from Outlook and Open in Excel
  8. What is the most efficient/quickest way to loop through rows in VBA (excel)?
  9. Embed picture in outlook mail body excel vba
  10. Copy data from another Workbook through VBA
  11. How to check for empty array in vba macro [duplicate]
  12. Use autofilter on more than 2 criteria
  13. What is the function of FormulaR1C1?
  14. Compiler Error: User-defined types not defined
  15. Open a workbook using FileDialog and manipulate it in Excel VBA
  16. Vba Excel do vlookup from a closed file
  17. excel hyperlink to nothing
  18. How to add headers to a multicolumn listbox in an Excel userform using VBA
  19. How to send files via HTTP_POST with Excel using VBA?
  20. VBA to open Excel hyperlink does not work when hyperlink generated with a formula
  21. How to Add Date Picker To VBA UserForm
  22. Vba macro to copy row from table if value in table meets condition
  23. Difference between Thisworkbook.name and Activeworkbook.name in VBA
  24. Set a cell value from a function
  25. Read VBA macros (or vbaProject.bin) of an Excel file without opening it in MS Excel [closed]
  26. simple vba code gives me run time error 91 object variable or with block not set
  27. VBA Function argument list select
  28. How do I get a list of unique values from a range in Excel VBA?
  29. How to get selected value in multicolumn listbox
  30. Query my excel worksheet with VBA

Leave a Comment