What is in your Range A1:B1 (Values?) << Also, What Sheet name is it
in?

What is the sheetname of your autofitered data?


"RCL" wrote in message
oups.com:

Hi JMay, If I use:
Criteria1:=Range("CR")
my Excel crashes !

Doing more research, I have discovered that my array must be in the
same row , so I changed my range CR, which now refers to A1 and B1.
Doing this I don´t get the error, but the filter doesn´t show
anything...

So, I still need help on how to convert

Criteria1:=Array("1", "2")

TO

Criteria1:=Range("A1:B1") or Range("CR")