hello
i m using array function in my below formula...but there is an debug error
what going wrong

Sub FilterNames()

Worksheets("ENTRY").Range("ALLTABLE").AutoFilter _
Field:=3, Criteria1:=Array(">=", "=") & Worksheets("ENTRY").Range("C8") _
, Operator:=xlAnd, Criteria2:="<=" & Worksheets("ENTRY").Range("C8")
Range("C9").Select

End Sub