AutoFilter Field on a none selectet sheet? 1

[ChristianDK]

Hello

Can anyone help me out on this topic:

I got a large Excel workbook and need to run it on some slow computers.

Sheets("sheet1").Select
Selection.AutoFilter Field:=1, Criteria1:="="

But I like to be able to use autofilter without selecting the sheet. Something like:

Sheets("sheet1").Selection.AutoFilter Field:=1, Criteria1:="="

Anyone know if this can be done and how?

 

[SkipVought]

Hi,

IMHO, Selection should be used almost NEVER in code, because you never know where either your fingers or someone elses fingers have been....

Sheets("sheet1").Range{"A1"}.AutoFilter _
    Field:=1, _
    Criteria1:="="

where A1 is in the filter.

Skip,

_[red][/red]

 

[ChristianDK]

Thanks Skip

You are the man!

some small info, dont use {} but () insted

 

[SkipVought]

Thanks. It was a moment of indecision between...

Sheets("sheet1").[A1]
and
Sheets("sheet1").Range("A1")

that came out incorrect.

Skip,

_[red][/red]