VBA Array Help in filtering data with logic

[大灰狼1976]

Hi malleshg!
Criteria1 must be a one-dimensional array.
You can modify it as below:

myarray2 = application.transpose(Sheet2.Range("a1:a5").Value)