VBA: Remove duplicates fails when columns array is passed using a variable

by

Put () around the array:

Sub test()

       Dim arrCols As Variant

       arrCols = Array(1, 2)

       '/This here works
       Sheet1.Range("$A$1:$B$10").RemoveDuplicates Columns:=Array(1, 2), Header _
            :=xlYes

       '/ Same code fails when the columns array is passed via variable
       '/ Error 5: Invalid procedure call or argument
        Sheet1.Range("$A$1:$B$10").RemoveDuplicates Columns:=(arrCols), Header _
            :=xlYes

 End Sub

It has to do with what vba is expecting to see.

More Related Contents:

  1. How to color all the rows based on the cell values
  2. How to get MS Excel to list files in a folder with their metadata (in particular, the tags created for the files)?
  3. Excel – opening file stuck on 100%, until VBA code finishes
  4. How to add a reference programmatically using VBA
  5. Copy Paste Values only( xlPasteValues )
  6. automatically execute an Excel macro on a cell change
  7. VLOOKUP with multiple criteria returning values in one cell
  8. VBA check if file exists
  9. How can I concatenate strings in VBA?
  10. Copy/Paste/Calculate Visible Cells from One Column of a Filtered Table
  11. Loading addins when Excel is instantiated programmatically
  12. Trying to use variables as values vba to sql
  13. How to call a macro from a button and pass arguments
  14. Copy Excel range as Picture to Outlook
  15. VBA (Excel) Dictionary on Mac?
  16. Paste Excel range in Outlook
  17. Refresh Excel VBA Function Results
  18. excel VBA run macro automatically whenever a cell is changed
  19. Code for looping through all excel files in a specified folder, and pulling data from specific cells
  20. VBa conditional delete loop not working
  21. Translate text using vba
  22. Concatenate column headers if value in rows below is non-blank
  23. Update excel sheet based on outlook mail [closed]
  24. Sending mail using Outlook where the Send method fails
  25. How do I apply a SumIf Formula in a VBA Sub? Getting Error 1004
  26. Using a variable for row in (row,column) for a range in VBA
  27. Unicode string literals in VBA
  28. Error13 in Excel VBA in data file
  29. How to get the path of current worksheet in VBA?
  30. How to open a workbook specifying its path

Leave a Comment