Filter between dates

  • Thread starter Dominique Feteau
  • 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
 
D

Debra Dalgleish

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

Selection.AutoFilter Field:=1, _
Criteria1:=">=" & weekbegin, Operator:=xlAnd, _
Criteria2:="<=" & weekend
 
D

Dominique Feteau

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top