filter

  • Thread starter Thread starter geebee
  • Start date Start date
G

geebee

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
 
You do not need to select the sheet but you do have to pass a range object to
autofilter..

If your headers are in row 1 in sheet 1 then you can use

Sheets("sheet1").Range("A1").autoFilter Field:=2, Criteria1:="test"
 
Back
Top