View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
RCL RCL is offline
external usenet poster
 
Posts: 10
Default 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")