PDA

View Full Version : Solved: Resize autofilter



khalid79m
11-12-2009, 05:13 AM
With Range("Int3_Graph1").Resize(, 23)
.AutoFilter Field:=1, Criteria1:=Sheets("Intervention_3.0").Range("C50").Value
.AutoFilter Field:=4, Criteria1:=Sheets("Intervention_3.0").Range("H50").Value
.AutoFilter Field:=3, Criteria1:=Sheets("Intervention_3.0").Range("M50").Value
'.AutoFilter Field:=23, Criteria1:=Sheets("Intervention_3.0").Range("R50").Value
End With


currently the final criteria is value of r50 however i need it to be greater than r50 can u assist

Bob Phillips
11-12-2009, 05:20 AM
.AutoFilter Field:=23, Criteria1:=">" & Sheets("Intervention_3.0").Range("R50").Value

khalid79m
11-15-2009, 02:08 PM
xld your the man :)