Autofilter on row 3

[khalid79m]

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 ?

[Mis_Sailesh]

Hi
Please attach the file for better understanding...

[Bob Phillips]

[vba]

With ThisWorkbook

.Worksheets("CM").Range("$A$3").CurrentRegion.Rows(1).AutoFilter
.Worksheets("CM").Range("$A$3").CurrentRegion.AutoFilter _
Field:=25, _
Criteria1:=.Sheets("Agent_View").Range("H8").Value
End With
[/vba]