I Want to Filter my sheet and want all data before current date and # N/A

[Altamash]

Here is my code and i am unable to filter data before current date.
can anyone please tell me how to do that.
I want to put that code in below bold codes.




Sub ReplaceNAwith0InColumnC()
'
' ReplaceNAwith0InColumnC Macro
'

'
Range("C1").Select
Selection.AutoFilter
ActiveSheet.Range("$A$1:$K$1000").AutoFilter Field:=3, Criteria1:="#N/A"
Range("C2").Select
ActiveCell.FormulaR1C1 = "0"
Range("C2").Select
Selection.Copy
Range(Selection, Selection.End(xlDown)).Select
ActiveSheet.Paste
Selection.End(xlUp).Select
Application.CutCopyMode = False
Selection.AutoFilter
Selection.AutoFilter
Range("D1").Select
ActiveSheet.Range("$A$1:$K$1000").AutoFilter Field:=4, Criteria1:="Check"
Range("E1").Select
Selection.AutoFilter
Selection.AutoFilter
Range("D1").Select
ActiveSheet.Range("$A$1:$K$1000").AutoFilter Field:=4, Criteria1:="Check"
Range("F1").Select
ActiveSheet.Range("$A$1:$K$1000").AutoFilter Field:=6, Criteria1:="<" & Now()


End Sub

 

[Altamash]

Hi,

Thanks for the help.
It worked by changing the folrmula.

 

[jorismoerings]

Hi,

No problem, we got here in the end and glad i could help.

 

[Altamash]

Hii,

Could you please check this.

Thread 'How to skip monday to fetch data from another workbook if particular date is holiday .' How to skip monday to fetch data from another workbook if particular date is holiday .