Use autofilter on more than 2 criteria

by

Use this one instead:

.AutoFilter Field:=1, Criteria1:=Array("HP Compaq 6000", "HP Compaq 8000", _
                                    "HP Compaq 8200", "HP Compaq 8200 Elite", _
                                    "HP Compaq dc5800", "HP Compaq dc7900", _
                                    "HP Compaq Elite 8300 SFF", "HP Compaq Pro 8300 SFF"), _
                    Operator:=xlFilterValues

More Related Contents:

  1. to make this code simpler
  2. VBA code takes long time to execute in excel
  3. VBA code required for Msg Box when two value equal in two cells
  4. Excel VBA deleting rows in a for loop misses rows
  5. What is the lifetime of a global variable in excel vba?
  6. Download attachment from Outlook and Open in Excel
  7. What is the most efficient/quickest way to loop through rows in VBA (excel)?
  8. Embed picture in outlook mail body excel vba
  9. How to check for empty array in vba macro [duplicate]
  10. Excel VBA Load worksheet in Function
  11. Searching an excel with two search words (multiple lookup) using vba macro [closed]
  12. Excel VBA – Combine rows with duplicate values in one cell and merge values in other cell
  13. Load csv file into a VBA array rather than Excel Sheet
  14. Insert line break in wrapped cell via code
  15. Change color of certain characters in a cell
  16. Want VBA in excel to read very large CSV and create output file of a small subset of the CSV
  17. Making VBA Form TextBox accept Numbers only (including +, – and .)
  18. Inserting an Online Picture to Excel with VBA
  19. Change length of For loop while in the loop
  20. VBA – Run Time Error 1004 ‘Application Defined or Object Defined Error’
  21. Consolidating worksheets into one
  22. VBA Macro crashes after 32000 rows
  23. How to create dynamic variable names VBA
  24. How to break a long string into multiple lines
  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. Run-time error ’91’ (Object variable or With block variable not set)
  28. How to have vba execute every 10 minutes?
  29. Read and write from/to registry in VBA
  30. Unable to read data from a CSV using ADO due to the driver thinking I am working with integers/number and showing nulls instead of text

Leave a Comment