I have a spreadsheet that lists many projects on it. M is the Start date and P is the Finish Date. I'm trying to filter out everything else that doesn't start and end between today's date. The code is below, but all it does is filter everything out. Does anyone know what I'm doing wrong?
Sub SetFilter()
ActiveSheet.Range("M1").AutoFilter Field:=1, Criteria1:=">=" & Now(), Operator:=xlAnd
ActiveSheet.Range("M1").AutoFilter Field:=4, Criteria1:=">=" & Now(), Operator:=xlAnd
End Sub
Sub SetFilter()
ActiveSheet.Range("M1").AutoFilter Field:=1, Criteria1:=">=" & Now(), Operator:=xlAnd
ActiveSheet.Range("M1").AutoFilter Field:=4, Criteria1:=">=" & Now(), Operator:=xlAnd
End Sub