Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Selecting a Dynamic Date Range Using AutoFilters
Sub DynamicAutoFilter()
    Worksheets("SalesReport").Select
    Range("A1").AutoFilter
    Range("A1").AutoFilter Field:=3,Criteria1:=xlFilterNextYear,Operator:=xlFilterDynamic
End Sub