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
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