hello
i m using below code to filter my data
i want filter data with blanks cells![]()
Sub FilterNamesOL() UnProtect_OL_BC Worksheets("OL BC").Range("OL_BC").AutoFilter _ Field:=11, Criteria1:=">=" & Worksheets("OL BC").Range("D6") _ , Operator:=xlAnd, Criteria2:="<=" & Worksheets("OL BC").Range("D6") Range("E9").Select Protect_OL_BC End Sub
thanx
Bookmarks