Query my excel worksheet with VBA

by

You can programmtically create an AutoFilter, then select the matching values:

Dim ws As Worksheet: Set ws = ActiveSheet

With ws
    .AutoFilterMode = False
    .Range("1:1").AutoFilter
    .Range("1:1").AutoFilter field:=2, Criteria1:="=Saturday", Operator:=xlAnd
    With .AutoFilter.Range
        On Error Resume Next ' if none selected
        .Offset(1).Resize(.Rows.Count - 1).Columns(2).SpecialCells(xlCellTypeVisible).Select
        On Error GoTo 0
    End With
    .AutoFilterMode = False
End With

More Related Contents:

  1. Refer to sheet using codename
  2. Excel tab sheet names vs. Visual Basic sheet names
  3. excel vba compare & copy worksheets from 2 excel files
  4. How to copy cells that contain certain text to another worksheet [closed]
  5. VBA Runtime Error 1004 “Application-defined or Object-defined error” when Selecting Range
  6. How do I base64 encode a string efficiently using Excel VBA?
  7. Assign event handlers to controls on user form created dynamically in VBA
  8. Programmatic Access To Visual Basic Project Is Not Trusted
  9. Can I make this macro more efficient or faster?
  10. How to get the background color from a Conditional Formatting in Excel using VBA
  11. VBA Excel Populate ListBox with multiple columns
  12. VBA Integer Overflow at 70,000
  13. How to count up text of a different font colour in excel
  14. How to “flatten” or “collapse” a 2D Excel table into 1D?
  15. VBA Macro to compare all cells of two Excel files
  16. What does ReDim Preserve do?
  17. VBA – How the colon `:` works in VBA code with condition
  18. How to create a separate CSV file from VBA?
  19. VBA: How to change the value of another cell via a function?
  20. Sending formatted Lotus Notes rich text email from Excel VBA
  21. How can I generate GUIDs in Excel?
  22. Range.Find not making a difference between January and November (February and December) in VBA Excel
  23. Remove Duplicates from range of cells in excel vba
  24. Excel Select vs Activate
  25. Fast compare method of 2 columns [closed]
  26. How can an Excel Add-In respond to events in any worksheet?
  27. Fastest way to check if two ranges are equal in excel vba [duplicate]
  28. Open Google Chrome from VBA/Excel
  29. Excel VBA Run-time error 1004 when inserting or value formula into cell
  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