Autofilter with column formatted as date

by

Dates can be tricky with Excel VBA AutoFilter. Some find it easier to just loop through the array to be filtered.

Sometimes I have found that one can use the numeric value of the date, especially when dealing with “dates between”

Criteria1:= ">" & CDbl([datecell])
Criteria2:= "<=" & CDbl(WorksheetFunction.EoMonth([datecell], 3))

Note that the above need to be “real dates” and not strings that look like dates. Even a single “string date” will mess things up.

More Related Contents:

  1. Excel VBA autofilter all but three
  2. ShowAllData method of Worksheet class failed
  3. Changing the date format to yyyy-mm-dd
  4. Excel VBA: Convert a date string to a Unix timestamp
  5. Convert month name into number
  6. AutoFilter – Use of SpecialCells
  7. SumIf using Excel VBA
  8. How can I call a macro which contains a loop but only run one iteration of that loop?
  9. Test or check if sheet exists
  10. How can I find last row that contains data in a specific column?
  11. Copy from one workbook and paste into another
  12. Open Excel file for reading with VBA without display
  13. Excel VBA App stops spontaneously with message “Code execution has been halted”
  14. How to remove all non alphanumeric characters from a string except period and space in excel?
  15. Find last used cell in Excel VBA
  16. Does Dir() make any guarantee on the order of files returned?
  17. Call a Sub with a String
  18. How to clear memory to prevent “out of memory error” in excel vba?
  19. Assign on-click VBA function to a dynamically created button on Excel Userform
  20. Is VBA an OOP language, and does it support polymorphism?
  21. What are .NumberFormat Options In Excel VBA?
  22. Excel: How to check if a cell is empty with VBA? [duplicate]
  23. Extract Data from Word Document to an Excel SpreadSheet
  24. Excel macro -Split comma separated entries to new rows [duplicate]
  25. Get text from clipboard using GetText – avoid error on empty clipboard
  26. Display milliseconds in Excel
  27. VBA editor auto-deletes spaces at the ends of lines
  28. Select entire column in table using Excel VBA
  29. Application.Quit command not closing the entire Excel Application
  30. How to protect Excel workbook using VBA?

Leave a Comment