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
Bookmarks