Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

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