khalid79m
03-30-2010, 05:08 AM
how can I autofilter on line 3
ThisWorkbook.Sheets("CM").Range("A3").AutoFilter Field:=25, Criteria1:=ThisWorkbook.Sheets("Agent_View").Range("H8").Value, Operator:=xlAnd
My code above puts the filters on row so I loose all the headers , not good
can anyone help ?:banghead:
ThisWorkbook.Sheets("CM").Range("A3").AutoFilter Field:=25, Criteria1:=ThisWorkbook.Sheets("Agent_View").Range("H8").Value, Operator:=xlAnd
My code above puts the filters on row so I loose all the headers , not good
can anyone help ?:banghead: