PDA

View Full Version : Autofilter on row 3



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:

Mis_Sailesh
04-02-2010, 01:12 PM
Hi
Please attach the file for better understanding...
:help

Bob Phillips
04-02-2010, 01:31 PM
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