Range inside Array not working
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")
|