Delete all duplicate rows Excel vba

by

There’s a RemoveDuplicates method that you could use:

Sub DeleteRows()

    With ActiveSheet
        Set Rng = Range("A1", Range("B1").End(xlDown))
        Rng.RemoveDuplicates Columns:=Array(1, 2), Header:=xlYes
    End With

End Sub

More Related Contents:

  1. Excel Number Separation [closed]
  2. excel vba compare & copy worksheets from 2 excel files
  3. VBA Stuck after certain loop
  4. How to avoid using Select in Excel VBA
  5. How to return a result from a VBA function
  6. Cycle through sub-folders and files in a user-specified root directory [duplicate]
  7. Convert Text to Date?
  8. Loop through each cell in a range of cells when given a Range object
  9. Checking for #N/A in Excel cell from VBA code
  10. Non-web SQL Injection
  11. Error: “Could Not Find Installable ISAM”
  12. Properly Handling Errors in VBA (Excel)
  13. Is there a way to slow down a Web Scraper so it will pick up the code?
  14. Create a folder and sub folder in Excel VBA
  15. One-dimensional array from Excel Range
  16. Renaming Files with Excel VBA
  17. How to copy only values in excel vba from a range?
  18. Run a Macro from Another Workbook
  19. Sorting a dictionary by key in VBA
  20. Handle “No cells were found” error when filtered range is empty
  21. VBA paste as values – how to
  22. Excel: the Incredible Shrinking and Expanding Controls [closed]
  23. What are the benefits of using Classes in VBA? [closed]
  24. Generate Word Documents (in Excel VBA) from a series of Document Templates
  25. Using Excel VBA Macro To Capture + Save Screenshot of Specific Area In Same File
  26. Type Mismatch in Loop to scan Outlook Messages [duplicate]
  27. Create folder path if does not exist (saving from VBA)
  28. Concatenate multiple ranges using vba
  29. How to highlight selected text within excel
  30. How to fix a VBA “type mismatch” error after switching to 64-bit Excel

Leave a Comment