hi,

i have the following:

Sheets("sheet1").Select
Cells.Select
Selection.AutoFilter
Selection.AutoFilter Field:=2, Criteria1:="test"

i would like to know if there is a way i can filter the sheet without
selecting it?

thanks in advance,
geebee