Filter between dates

  • Thread starter Thread starter Dominique Feteau
  • Start date Start date
D

Dominique Feteau

I recorded a macro that would filter the dates in column A between two
dates. I looked at the code and made some edits and came up with this after
a little bit of tweaking:

Sub ChangeWeek()

Dim weekbegin As Date
Dim weekend As Date

weekbegin = InputBox("Week Beginning")
weekend = InputBox("Week Ending")
Selection.AutoFilter Field:=1, Criteria1:=weekbegin, Operator:=xlOr _
, Criteria2:=weekend

End Sub

Only problem is that the code above only shows me those 2 dates. I need the
dates in between too.

I know its something simple, but I cant figure it out. Any help would be
cool.

Thanks
Niq
 
Use the And operator, and >= and <= for the date operators:

Selection.AutoFilter Field:=1, _
Criteria1:=">=" & weekbegin, Operator:=xlAnd, _
Criteria2:="<=" & weekend
 
i knew it was easy.

thanks
niq

Debra Dalgleish said:
Use the And operator, and >= and <= for the date operators:

Selection.AutoFilter Field:=1, _
Criteria1:=">=" & weekbegin, Operator:=xlAnd, _
Criteria2:="<=" & weekend
Click to expand...
 
Back
Top